Nevermind, I think I will repost without an example so you can focus on the
real problem...

"Ashish Mathur" wrote:

Hi,

You table array is the entire column A (that is 65,536 rows). Please reduce
the range to where your data is till and then see whether Excel still
crashes.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"pcbins" wrote in message
...
While typing a vlookup function such as "=vlookup(A2,'Sheet2'!A:A,false)",
immediately after typing the "f" in "false", Excel will crash with the
following error:

Identify Label
There is more than one cell with this label:f
Select the cell containing the label to use:
[OK] [Cancel]

No matter what is entered following, the following error will occur:

Microsoft Office Excel has encountered a problem and needs to close.
We are sorry for the inconvenience.

This problem has been around for almost 5 years now. Is there a hotfix for
it yet? Or should I give MS another 5 years to work on it?