Hi there,
I've been trying to do an Index-Match that references another workbook, and I've been running into problems with the Match lookup_value. It keeps coming in as text with an apostrophe on either side when embedded in the Index-Match. When done outside of the Index-Match formula...