Lookup Table using text?

[EssKayKay]

Hello,
I was trying to use a lookup table to return results. However, my formula was returning faulty answers. The lookup column B contains text, the result column C contains values. Some of the results were correct, others not.

As a simple example:
Lookup cell: C2
Formula cell: C3
Formula: =VLOOKUP(C2,B7:C10,2)
Lookup Range: B7:C10

If I enter ONE in C2 it returns 1 in C3 which is correct
If I enter TWO it returns 2 which is correct
If I enter THREE it returns 1 which is INCORRECT
If I enter FOUR it returns N/A

Maybe instead of using lookup table I’ll just concatenate If statements instead (I may need help on this later). However, I’m still wondering why this lookup table does not work.

Thanks for viewing,
Steve K.

 

[Sanjeev1976]

Hi Steve,

Change the formula as below :

=VLOOKUP(C2,B7:C10,2,False)

 

[EssKayKay]

Hi Steve,

Change the formula as below :

=VLOOKUP(C2,B7:C10,2,False)

Thank you Sanjeev that did it. Could you explain what the True/False does? I was not aware of that.

Thanks again,
Steve

 

[Sanjeev1976]

True returns an approximate match and false returns an exact match

 

[EssKayKay]

True returns an approximate match and false returns an exact match

Ahhh - thank you so very much. Did not know that. I guess even old guys like me can still learn.