vlookup problem when value absent

N

new_121

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 :(
 
D

DazzaData

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
 
N

new_121

Thank you DazzaData. It helped.

DazzaData said:
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
Click to expand...
 
Top