Thread: Vlookup
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Vlookup

Dave

Semi-colons versus commas are a Windows Regional Settings thing.

North America uses the comma exclusively. Move to Europe and you will find the
semi-colons in wide use.


Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 14:08:00 -0700 (PDT), Dave wrote:

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.