vlookup problem when value absent
 

Hi,

Does anyone know, what formula I should use, if I would like to vlookup for
certain thing (name) and return the value in column 1 if the value is
different from zero, but look at the column 2 in case vlookup in column 1 is
zero.
And if vlookup in column 1 and column 2 turn to be zero then vlookup the
value in column 3 - if that is empty as well then return "" (nothing).

Please help me, because I'm stuck with this formula :(

vlookup problem when value absent
 

Hi,

You kinda answered your own question in the last para:)

IF (VLOOKUP#1<0,VLOOKUP#1, (IF VLOOKUP#2<0,VLOOKUP#2,VLOOKUP#3) )

Actually there may be a whole other way of dealing with this issue rather
than nest ifs and vlookups, but you would need to set out the problem more
fully for us

Cheers


"new_121" wrote:

Hi,

Does anyone know, what formula I should use, if I would like to vlookup for
certain thing (name) and return the value in column 1 if the value is
different from zero, but look at the column 2 in case vlookup in column 1 is
zero.
And if vlookup in column 1 and column 2 turn to be zero then vlookup the
value in column 3 - if that is empty as well then return "" (nothing).

Please help me, because I'm stuck with this formula :(

vlookup problem when value absent
 

Thank you DazzaData. It helped.

"DazzaData" wrote:

Hi,

You kinda answered your own question in the last para:)

IF (VLOOKUP#1<0,VLOOKUP#1, (IF VLOOKUP#2<0,VLOOKUP#2,VLOOKUP#3) )

Actually there may be a whole other way of dealing with this issue rather
than nest ifs and vlookups, but you would need to set out the problem more
fully for us

Cheers


"new_121" wrote:

Hi,

Does anyone know, what formula I should use, if I would like to vlookup for
certain thing (name) and return the value in column 1 if the value is
different from zero, but look at the column 2 in case vlookup in column 1 is
zero.
And if vlookup in column 1 and column 2 turn to be zero then vlookup the
value in column 3 - if that is empty as well then return "" (nothing).

Please help me, because I'm stuck with this formula :(