VLOOKUP RETURNING WRONG VALUE

[kennyslaterr]

Hello!

Can anyone tell me what im doing wrong?? im trying to do a VLOOKUP to grab data from another sheet and for some reason it is returning an incorrect value?? Ill attach an image from each worksheet. The value i should be getting is '2021' and its giving me '2019' Thanks! (also when i try to add false to get exact i just get NA)

 

[DanteAmor]

If you search by vendor name, you should look in column B, it should be like this:

=VLOOKUP(A34,Sheet2!B:C,2,0)

If you search by vendor number, you should search in column A, it should be like this:

=VLOOKUP(B34,Sheet2!A:C,3,0)

Notice at the end of the formula, the parameter 0, is to indicate that the match is exact.

 

[kennyslaterr]

If you search by vendor name, you should look in column B, it should be like this:

=VLOOKUP(A34,Sheet2!B:C,2,0)

If you search by vendor number, you should search in column A, it should be like this:

=VLOOKUP(B34,Sheet2!A:C,3,0)

Notice at the end of the formula, the parameter 0, is to indicate that the match is exact.

Thankyou so much!