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