ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "Identify Label" bug when using INDEX/MATCH and VLOOKUP formulas (https://www.excelbanter.com/excel-worksheet-functions/186033-identify-label-bug-when-using-index-match-vlookup-formulas.html)

Exceller

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


All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com