My formula is: =VLOOKUP($A2,Sheet1!A:D,4,0) and the message returned in the cell is #N/A (Value not available error).
I've used this formula in other worksheets and it has worked fine. The lookup field is a number that can also have a - or letter assigned to it (i.e. 1010-B). I tried changing the numbers to text to see if that would help, but it did not.
I am not sure how to solve and am not sure what I am missing. Any guidance is appreciated.
Bookmarks