Kris wrote...
Nope, the name is exactly the same, spacing and everything. *Still returning
the #NA reference.
....

Then if, say, cell '[Excel Report MI.xls]Data Entry'!A35 looked the
same as cell I20 in the active workbook/worksheet, what does the
formula

='[Excel Report MI.xls]Data Entry'!A35=I20

return? If it returns FALSE, what do the formulas

=LEN('[Excel Report MI.xls]Data Entry'!A35)

and

=LEN(I20)

return? If they return different numbers, then what does the formula

=TRIM('[Excel Report MI.xls]Data Entry'!A35)=TRIM(I20)

return? If this last formula returns TRUE, then the cell for which the
LEN formulas above returned the larger number almost certainly does
contain trailing spaces which you wouldn't be able to see unless you
edit that cell and move the insertion point (vertical bar cursor) to
the end of the cell's contents.

If the first formula above returns TRUE but your formula

=VLOOKUP(I20,'[Excel Report MI.xls]Data Entry'!$A$13:$DH$68,112,FALSE)

returns #N/A, then you may have found a true bug in Excel unless your
I20 name contains certain special characters. In which case you'd need
to show us the troublesome I20 value.