No, it doesnt matter what size the array is. It is rarely the entire column.
RARELY EVER. It can be 500 rows or 5000 or 50000. It makes no difference.

PLEASE ADDRESS THE PROBLEM, MICROSOFT, and provide a fix. I think 5 years is
long enough to have researched it.

"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?