Hi Andy

Don't think its a bug!!!
Your data range is 2 columns wide A:B and you are trying to use an
offset of 16!!

--
Regards

Roger Govier


"andy_suffers_Excel_2003_over-engineering"
icrosoft.com wrote in
message ...
Hi. I use VLOOKUP formula's every single day - I use them A LOT !
My current machine has Ms Excel 2003.

A normal Vlookup formula looks like :

=VLOOKUP(A2,Sheet1!$A$16:$B$21,16,FALSE)

Prior to Ms Excel 2003, I have NEVER had a problem with Vlookup
formula's.

HOWEVER.....Some "Genius" Programmer at Excel has bugged the Worksheet
command.

Now, when I go to type "FALSE" at the end of a Vlookup command, Excel
suddenly opens a Dialog Box looking to "Identify Label"....

If I try to close this box or cancel it - Excel crashes with the loss
of all
unsaved work.

There does not seem to be any means of turning this damned function
off
either.

It seems to me a classic case of somebody trying to 'Fix' Excel when
it's
not broken.


PLEASE PLEASE....If there's any download, bug fix or <ANYTHING I can
do to
stop this damned dialog box opening up and crashing Excel - I would
LOVE to
know what it is.

Thanks,
A.