=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

On Sat, 16 Feb 2008 19:56:00 -0800, ManchVegasMarty
wrote:

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