Thread: Vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave[_6_] Dave[_6_] is offline
external usenet poster
 
Posts: 21
Default Vlookup

Hi Kimmer,
Never too old.
Your VLOOKUP statements are separarted by commas. I use XL2000, and I
need to use semicolons, or else I get error messages. Is this it, or
is it just a version thing?
Did you use the function input thingywhen you created the formula? It
helps remove the possibility of spelling errors and typo's.
Also, your VLOOKUP formula should really have a 4th statement after
the 2, which in your case should be ;FALSE.

Regards - Dave.