Help with vlookup, getting #N/A for all values

[MetroBOS]

I checked my formula several times and I can't seem to figure out why it's creating an error.

Can someone please take a look at the attached file and help me figure out where the issue is?

[Jonmo1]

The values in column A of Sheet1 are not realy numbers, They're 'Numbers Stored As Text'

Try highlighting that column, and on the Data Tab, click Text To Columns
Select Deliminated and click Finish.

[Pete_UK]

You can match on some of them if you do this in B2:

=IFERROR(VLOOKUP(A2&"",Sheet1!$A$2:$D$9196,4),"")

(changes shown in red), or this if you need an exact match:

=IFERROR(VLOOKUP(A2&"",Sheet1!$A$2:$D$9196,4,0),"")

Then copy down.

Hope this helps.

Pete

[Raymundus]

The Data in Sheet1 Column A are numbers stored as text. You must convert them to numbers in order for your vLookup to function properly. Aftrer you do this, the formulas will not recalculate automatically. You will need to fo to the Formula tab in the Ribbon, and on the far right side, click Calculate now.

[MetroBOS]

Thanks everyone!

[Jonmo1]

You're welcome.