VLOOKUP Problem

[NeoSez]

I have a formula

=IF($A2="","",VLOOKUP($C2,$R:$S2))

The problem is, it does not recognize 2313A and returns a lookup of 123 instead
And 456 returns a lookup of 2313A
Why is it doing this?
Spent days looking at this and can not figure out why.
The lookup list is something like this :
Columns R & S

123	123 Go
456	456 big
789	789 or
1011	1011 Not
2313A	2313A Atall

 

[StephenCrump]

If your formula is producing results, I assume it is:

=IF($A2="","",VLOOKUP($C2,$R:$S,2))

Have a look at help for the VLOOKUP function. For an exact match, you need to specify the third argument [range_lookup] as FALSE.

 

[kweaver]

In the VLOOKUP you need to identify which column you want returned (e.g., 2) followed by a comma followed by FALSE

 

[NeoSez]

If your formula is producing results, I assume it is:

=IF($A2="","",VLOOKUP($C2,$R:$S,2))

Have a look at help for the VLOOKUP function. For an exact match, you need to specify the third argument [range_lookup] as FALSE.

StephenCrump Thank you!!! That was it. Works now.​

 

[NeoSez]

In the VLOOKUP you need to identify which column you want returned (e.g., 2) followed by a comma followed by FALSE

kweaver Yes, that was it. It solved the issue. Thank you as well.​