Vlookup with different cell formats

[lewap90]

Hi guys,

when i try to vlookup numbers from the enclosed file i encounter errors. Strange is when i edit cells in data column and i hit enter, formula in vlookup column is working properly. I dont know how to format data and vlookup column to get all the results. Any help appreciated

[FDibbins]

Try this...
=IFERROR(VLOOKUP(--I5,$A$2:$B$6000,2,0),VLOOKUP(TEXT(I5,0),$A$2:$B$6000,2,0))

You have a mixture of both numbers, and text looking like numbers, in both columns, that is what is causing teh problem

[lewap90]

it is working thank you so much but i dont know what "--" does before I5?? (--I5)