V look up dont work

[WendyWoo1]

I am trying to do v look ups with matching data, although the values come up as N/A. If I click after the number on the look up sheet and press enter the number will populate however there are far too many numbers to do this manually. I have made both sets of numbers the same. Ie, numbers, text, general etc but nothing seems to work? Any ideas?

[Pete_UK]

Post your workbook - it can probably be solved by adding *1 to a parameter in your formula.

Pete