help with formula
 

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

help with formula
 

=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

help with formula
 

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
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"ManchVegasMarty" wrote in
message ...
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

help with formula
 

thank you so much! Your help is greatly appreciated.

-Marty

"Gord Dibben" wrote:

=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

help with formula
 

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

On Sun, 17 Feb 2008 06:03:02 -0800, MartyRock
wrote:

thank you so much! Your help is greatly appreciated.

-Marty

"Gord Dibben" wrote:

=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