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?