Thread: VLOOKUP output
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Freddie Freddie is offline
external usenet poster
 
Posts: 6
Default VLOOKUP output

Hi. I need to use an if formula

If the VLOOKUP formula in the "list" sheet doesn't find any information in
the "price" sheet, I want to use an IF formula to get information from
another column in the "list" sheet.
But if the VLOOKUP formula cant find any information in another sheet but
the output is (in swedish) #saknas! (I think it returns #N/A in english) so I
cant use the IF formula.