He used =Vlookup(A2,Sheet2!A2:B50,2,0) Works on some rows, #NA on others (the item being looked for is always there)
I used =Vlookup(A2,Sheet2!A:B,2,0) it works
(I have told him 100 times to name his ranges, but he is stubborn)
Just curious why his formula won't work on all rows . . .