help with formula

[ManchVegasMarty]

Thanks for reading

In Cell (A1) I have a drop down menu that has a validated series of billing
codes: None, 2010, 2011, 2012, 3010, 3011, 3012

In Cell (A2) I would like to assign a number value that applies to each
billing code in (A1). None = 0, 2010 =27.5, 2011 =100, 2012 =12.50,
3010=27.5, 3011 =100, 3012 =12.5.

So in Cell (A2), I need a forumla that will read cell (A1) once the value is
selected from the drop down menu and assign the correct value (above) to cell
(A2)

Is this possible?

Signed,

Freezing in New Hampshire

 

[Gord Dibben]

=LOOKUP(A1,{"None",2010,2011,2012,3010,2011,3012},{0,27.5,100,12.5,27.5,100,12.5})

entered in A2


Gord Dibben MS Excel MVP

 

[Ragdyer]

You could place your parameters in a datalist, located in an out-of-the-way
location in your sheet, and then use a formula with the Vlookup() function
in A2.

Check out this web page of Debra Dalgleish for instructions:

http://www.contextures.com/xlFunctions02.html

 

[MartyRock]

thank you so much! Your help is greatly appreciated.

-Marty

 

[Gord Dibben]

Thanks for the feedback.

Note RD's advice about using a table and VLOOKUP.

That would give you more flexibility for making changes if need be.


Gord