Retrieve Value from Cells (Excel 2003)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote