Excel Crashes after typing "false" in VLookup

P

pcbins

While typing a vlookup function, 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?
 
S

Shane Devenshire

Hi,

0. Try: Tools, Options, Calculation, and uncheck Accept labels in formulas.

1. Can you get around the problem by using 0 instead of False? Or in fact
by using something like

=VLOOKUP(A1,Table,4,)

Without entering False or 0 just the comma?

2. Take a look at this article.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel crashes when typing "false" in VLookup function 17
Excel Crashes when typing "False" in VLookup formula 11
Excel VLookup crash when typing "false" 2
Excel 2002/2003 vlookup crash while typing 'false' argument 5
VBA userform Vlookup Excel 1
if and vlookup formula combination 4
Excel 2007 Crashes on one line event macro 0
Excel crashes after running solver 0

Top