IF statement not working for selecting cell from range

**swimwsr** · 11-28-2011, 01:05 PM

I am trying to make an IF statement in cell D3 that will say IF C3 is equal to any of the cells from A1:A30, then D3 will equal the cell to the right of the equivilent cell (such as B20 if A20=C3) I cannot seem to find a quick way of doing this, besides entering a very long IF statement. Please help. Thanks

**Ron Coderre** · 11-28-2011, 01:16 PM

Since you're using Excel 97...
If you're sure the C3 value will be in the A1:A30 list, try this:
D3: =VLOOKUP(C3,$A$1:$B$30,2,0)

Otherwise, try this:
D3: =IF(COUNTIF($A$1:$A$30,C3),VLOOKUP(C3,$A$1:$B$30,2,0),"No Match")

I *think* Excel 97 has the COUNTIF function.

Does that help?