Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|