Drop down list attached to specific row

[mobile63]

Hi Guys, I need help. I would like to optimise my drop down list/box. by attaching a row of 10-20 cells of calculations to each selection from the drop down list. For example if I choose a month like February than I would like to populate the row with calculations for February, if I choose August then the August calculation row will appear.

 

[MarkCBB]

Hi there mobile63,

there area a few ways to do this, can you perhaps tell me what the calculations are? just 3 or 4 and what is thier cell locations (i.e. A1).

thanks.

however below is an example you might be able to use,

i.e. if your drop down list is in A1, and yout first formula/funcation is in B1, then in B1 you can use a IF funcation, i.e. =IF(A1=January,A2*B2-C1,"").

 

[Michael M]

Hi and Welcome to the Board.
That might be something you could recommend to Bill Gates. Wouldn't that be great to simply select a formula from a list. Afraid not, you will have to do it with VBA

 

[MarkCBB]

I hope I am understanding the questions correctly here, but I was thinking. using the CHOOSE function with VLOOKUP, and then the formula/function for the CHOOSE selection.

=CHOOSE(VLOOKUP($A$1,{"January",1;"February",2;"March",3;"April",4;"May",5;"June",6;"July",7;"August",8;"September",9;"October",10;"November",11;"December",12},2,FALSE),2*2,2*17,"next formula,next formula)

 

[mobile63]

Thank you Mark for your quick reply. For example If I would like to have in A4 a drop down list of 12 items/selections. By selecting an item like February from the list, in A4 then the calculation will follow in B4..M4. Once the syntax/calculation is working then I can attach calculations to all 12 months. The outcome should be that I will copy the drop down list from A4 to A16, and by selecting the month i will have the relevant calculation. Thank you in advance Regards Stefan

 

[MarkCBB]

Try this.

=CHOOSE(VLOOKUP($A4,{"January",1;"February",2;"March",3;"April",4;"May",5;"June",6;"July",7;"August",8;"September",9;"October",10;"November",11;"December",12},2,FALSE),Jan,feb,mar,Apr,may,jun,jul,aug,oct,nov,dec)

Jan = your formula for B4 january
Feb = your formula for B4 feb
Mar = your formula for B4 mar
apr = your formula for B4 apr
then drag the formula across to C4, and chance the formulas

 

[mobile63]

Hi Mark. Thank you very much for your answer. I will have a go and I will let you know. Thanks again

 

[Michael M]

Hi Mark
Obviously then .......I was the one that misunderstood the OP's request...Cheers !

 

[mobile63]

Hi Mark. Sorry but this will give me just one answer/value. When choosing a value from list ie February in A4 then the answer should come up in B4..M4 where every cell has a different value. The list will be 12 cells in A4, and I will have 12 rows of 16 horizontal each matched w the list. My goal is to be able to have values and then choose the attached calculation through the drop down list. I never tried VBasic and I am trying to avoid it. At the moment i am cutting and pasting the formulas (row), and I am manually checking the values. Thanks

 

[MarkCBB]

HI there Mobile63,

When you drag the formula form B4 to C4, then just update the formulas, and so on in D4, until M4.