I need some help with the VLOOKUP. I have created a table in Colunm A & B like this..
F8ZZ16054AA YR3316044AA
F8ZZ16055AA 1R3316045AA
YR3Z16055AA 2R3316F001AB
1W1Z16138AA 2W138A297AA
F4ZZ16707A 1R3316774AA
XR3Z9B081BA XR339A179AD
2C3Z16K007AA 3C3416K007AB
My formula in D1 looks like this.. =VLOOKUP(C1, A1:B7,2) With my input being C1...Problem is when I input the first # and the second # I get the b5 output..not the b1..? When in use A3...i get B7... what am I doing wrong..?
F8ZZ16054AA YR3316044AA
F8ZZ16055AA 1R3316045AA
YR3Z16055AA 2R3316F001AB
1W1Z16138AA 2W138A297AA
F4ZZ16707A 1R3316774AA
XR3Z9B081BA XR339A179AD
2C3Z16K007AA 3C3416K007AB
My formula in D1 looks like this.. =VLOOKUP(C1, A1:B7,2) With my input being C1...Problem is when I input the first # and the second # I get the b5 output..not the b1..? When in use A3...i get B7... what am I doing wrong..?