View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kris W Kris W is offline
external usenet poster
 
Posts: 1
Default Vlookup referencing more than one worksheet

Hi

(Excel 2003)

I have a vlookup formula in worksheet A, which looks up worksheet B, but I
need it to look up worksheet C also - how do I do this?

I also need it to say "Not Listed" instead of "#N/A" as it does at the
moment...

Thanks!