View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andy_suffers_Excel_2003_over-engineering andy_suffers_Excel_2003_over-engineering is offline
external usenet poster
 
Posts: 2
Default Vlookup - Identify Label - Excel Programming Bug

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.