View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
new_121 new_121 is offline
external usenet poster
 
Posts: 7
Default 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 :(