LOOKUP?

[Keith - NRCS]

I've got another formula question if someone could please help.

I have a list of CRP Practices (columnA) some of which pay out a bonus of
20% and some do not. The CRP Practices are in a drop down list in columnA. I
want the SRR Bonus (columnB) to automatically enter "20%" or "None" depending
on which corresponding CRP Practice is selected in columnA. I tried to use
the LOOKUP command but it doesn't always work and I believe it has something
to do with the practices not being in numerical order (according to Excel). I
could sort them, but I'd rather they stay in the order that I choose...not
how Excel sorts them.

Any suggestions?

EX:

Column A Column B
CRP Practice SRR Bonus
CP-5A 20%
CP-16A N
CP-21 20%
CP-23A 20%
CP-25 N

 

[Keith - NRCS]

OK its working sort-of...is there a way to get "None" in Column B if the 20%
bonus does not apply?

 

[Keith - NRCS]

THANKS!