Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Retrieve Value from Cells (Excel 2003)

    Hi

    Is there a formula to get the value of the cell on the left column to the cell of the current column if there is a value in it other than 0.
    If the cell in the left column show 0, then get the value of the cell above the current cell in the same column.
    There will always a value > 0 in the cell of the left column or the cell above the current cell in the same column.

    Thanks
    regards, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Retrieve Value from Cells (Excel 2003)

    Say that the currenct cell is C20.
    The following formula will retrieve the value of the cell to the left, or if that is 0, the value of the cell above:

    =IF(B20=0,C19,B20)

    You can copy C20 to other cells, the cell references will be adjusted automatically.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Retrieve Value from Cells (Excel 2003)

    Hi Hans

    Thanks. the formula does works. However, I need to apologise that I didn't look at my spreadsheet well enough
    before posting. I need to retrieve the value of the cell to the left, or if that is 0, the value of the cell above and
    if it is 0, retrieve the value from the same row in Column E. These data are in pairs of names and need to extract
    the value corresponded to the names.

    I have attached a small sample to show the dataset and the result I want is highlighted.

    Thanks

    regards, francis
    Attached Files Attached Files
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Retrieve Value from Cells (Excel 2003)

    You should be able to extend the formula I posted to do what you want.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •