vlookup problem when value absent

[Guest]

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

 

[Guest]

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

 

[Guest]

Thank you DazzaData. It helped.

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