I'm trying to match data from 1 spreadsheet to another using the index
function. I have tried formatting the data on each sheet to general, tried
the "Text to Columns" all to no avail.

When the results come back I get an #N/A.

VLOOKUP won't allow a false Range Lookup.

What can I do to make this work??