Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Identify Label" bug when using INDEX/MATCH and VLOOKUP formulas
I never had this issue before today:
When I used INDEX/MATCH and VLOOKUP formulas this morning (formulas that I have used successfully and without incident thousands of times) I received a dialog box asking me to identify the Label. I pressed "Cancel" and then Excel shut down. I have received the same outcome every time I have used these formulas since then. I have disabled "Accept labels in formulas" in the Options---Calculation menu and also disabled all Add-ons but I still get this error. I have not found any useful information on how to correct this. Please let me know how to reconcile this. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
How to replace "#N/A" w "0"when vlookup couldn't find the match? | Excel Discussion (Misc queries) | |||
how to start using vlookup, match & index formulas, examples | Excel Worksheet Functions | |||
Help please - Index and Match "like" values | Excel Worksheet Functions |