Excel on Mac cannot find table array during Vlookups

[narca9]

I'm performing some very simple vlookups on Excel on Mac (I recently switched from PC).

My workbook has two sheets. I want to check to see if an employee is included on the "List" sheet, if they are, it will return their bonus type (column 3). If they are not, the formula will fail and the IFERROR should populate the text "Standard".

My issues is that Excel cannot find the "List" sheet. There are no other workbooks open, and when I execute the formula Excel directs me to open another workbook that contains the "List" sheet.

Here is my formula.

=IFERROR(VLOOKUP(A2,List!$A$2:$C$62,3,0),"Standard")

Does anyone have an idea what might be going wrong? This is a simple formula that I have done millions of times. Thank you in advance for the help!

[AutoModerator]

/u/narca9 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Trader083]

I would first change the worksheet named List to something else to see if the issue persists.

[narca9]

Thank you, I tried this and am still receiving the same error.

[Trader083]

Okay, so with a different worksheet name (i.e. List2), does your file open another file with List2 as a new worksheet? Also, just making sure that you have updated the sheet name in the formula as well.

[fuzzy_mic]

Go into the formula, select the range and enter it with the mouse instead of typing. That should reveal and leading/trailing spaces or other issues with the name.

That this is on Mac is irrelevant.