VLOOKUP - #N/A Error

  • Thread starter Thread starter sowetoddid
  • Start date Start date
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 ??
 
Hi
probably your numbers are stored as text values. try the following:
- select an empty cell and copy it
- select the range with your values
- goto 'Edit - Paste Special' and choose 'Add'
 
Back
Top