I would just go to ToolsOptionsCalculation and uncheck "Accept labels in
formulas"

Does that rectify the problem?

If so, check out and see where you may have conflicting ranges with label names.

This KB article for excel 97 gives this bit of info. Could be it also applies
to newer vesrions but article not updated.

http://support.microsoft.com/kb/161881/en-us

If multiple tables on the same worksheet contain identical labels, the table
Microsoft Excel uses is determined by the location of the cell that contains the
formula. In general, the table that is referenced is to the left and/or above
the cell that contains the formula.

For example, if a worksheet contains a table in cells A1:E10 and a table in
cells A15:E25, if you type a formula in cell A30, Microsoft Excel uses the
labels in the table in cells A15:E25. However, if you type the same formula in
cell A12, Microsoft Excel uses the first table in cells A1:E10. If Microsoft
Excel is unable to determine to which table you are referring, it displays the
"Identify Label" dialog box. This dialog box prompts you to select the cell that
contains the label you want to use.


Gord Dibben MS Excel MVP

On Thu, 21 Sep 2006 08:52:02 -0700, andy_suffers_Excel_2003_over-engineering
icrosoft.com wrote:

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.