Vlookup
I’m using VLOOKUP but not getting the correct results.
Sheet1 (Reference Table)
Column A = License No.
Column B = State
Sheet2
Column A = License No.
I have to pull in the states that correspond to each license number.
Below is my formula. Some return values are correct are some are not. I cannot figure out why this is happening.
=VLOOKUP(A2,'Sheet1'!$A$2:$B$141,2)
Your help is greatly appreciated
|