BUG: VLOOKUP Confused by Commas in Sheet Names
VLOOKUP treats commas in sheet names as argument separators (attachments 1-3).
To troubleshoot, I replaced the single quotes delimiting the sheet's name with double quotes. At first sight, the double quotes do away with the confusion (attachment 4), but they are not accepted when attempting to enter the formula (attachment 5).
This seems to be a bug, but I couldn't find a way to report bugs for Excel. The feedback buttons in my Excel are greyed out.
EDIT: The comma used to reference a column in a table (VLOOKUP(A1,Table[[#All],[Column]],1,FALSE)) seems to not confuse VLOOKUP at all.
Good point, Roy. I don't see a way to update my post to reflect your observation.