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.
|