S
sowetoddid
I have a sheet that uses the VLOOKUP function to match values wit
another sheet in a different workbook. Why does the #N/A show randoml
as the result of the equation.
For example, ID number 30092100 should match with Plnt. C, but instea
it show "#N/A". If I locate 30092100 on the reference workbook an
bring up the cursor in that cell, then it activates something. Goin
back to the VLOOKUP equation reveals that the "#N/A" is now replace
with the true "Plnt. C" value.
??? What's going on ??
another sheet in a different workbook. Why does the #N/A show randoml
as the result of the equation.
For example, ID number 30092100 should match with Plnt. C, but instea
it show "#N/A". If I locate 30092100 on the reference workbook an
bring up the cursor in that cell, then it activates something. Goin
back to the VLOOKUP equation reveals that the "#N/A" is now replace
with the true "Plnt. C" value.
??? What's going on ??