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

If you don't want to sort them, then use VLOOKUP() with FALSE as the 4th
argument...

e.g

=VLOOKUP(A1,list_table,2,FALSE)

will lookup the value from A1 in your 2-column list_table and extract
from the 2nd column (independent of sort order).


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116328

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

"NBVC" wrote:


If you don't want to sort them, then use VLOOKUP() with FALSE as the 4th
argument...

e.g

=VLOOKUP(A1,list_table,2,FALSE)

will lookup the value from A1 in your 2-column list_table and extract
from the 2nd column (independent of sort order).


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116328

Isn't that in the table as "N"?

just change the "N" in the table to "None".


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116328

THANKS!

"NBVC" wrote:


Isn't that in the table as "N"?

just change the "N" in the table to "None".


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116328