Why is this VLOOKUP not working? (Attached workbook)

[stan255]

Hi, I have no idea why this VLOOKUP is not working. I'm trying to match column A,B with column F,G but its always giving me an "N/A".
matchnotworkingpic.png
I have attached a sample workbook.
matchnotworking.xlsx
Any ideas?

[FDibbins]

Without looking at you file, I would say that 1 set of data is text, looking like numbers,and the other is real numbers

Assuming you are searching for the data in column A, try =vlookup(--A2,..................

[zbor]

Because in A column you have numbers stored as text.
That's usually is not a good idea.

Select A2 cell, press F2 key and enter and it will work.

[stan255]

@FDibbins @zbor I love you guys! You're right, its the text column that is causing the problem.

[samba_ravi]

c2=IFERROR(VLOOKUP(A2,F:G,1,0),VLOOKUP(A2+0,F:G,1,0))

Please Login or Register  to view this content.

Try this
In your sheet, Column A is in Text Format and whereas Column F is in number format, that's why your formula is not working

[FDibbins]

Happy to help, thanks for the feedback