Formula based on which item is selected in combo box.

I attached a sample of what I am trying to do.

On Sheet 1 I select something in the combo box. I then enter a number into the yellow cell. Based on what it is I selected in the combo box I need to run a certain formula and have the answer fall into Sheet 1 cell F3.

Example: Select Spyker and enter 1200 into the yellow box, the formula would be =IF(E3>0,E3/(Sheet2!B3*58.75),"") and then Sheet1 F3 would give me the answer of 8.17.

Everytime I select a different item in the combo box it would have to use the corresponding info.

Thanks for looking.

1:link combo box to cell d3 (go to design mode,right click combo box/properties and type d3 in linked cell) exit design mode
2. in f3

=IF(E3>0,E3/(VLOOKUP(D3,Sheet2!A:B,2,FALSE)*58.75),"")

Originally Posted by NBVC

Did you set a linked to Cell behind the combobox so that the actual cell E3 actually populates?

E3 is populated by the user, it could vary.

D3 is the connection for the "Spyker". How do I link other items in the combo box if I already pointed the linked cell to d3?

it doesnt work like that. whatever you select in the combo box then populates the linked cell

It works great. I now kinda understand it. I have been altering it to my needs actually.

Sometimes on sheet2 I may have a blank cell so I can actually select nothing then in the combo box. Is it possible to alter the formula so that when nothing is selected in the combo box, E3 & F3 clear as well?

since e3 is manualy entered you cant hav a formula in e3 as well, i supose a vba script could be written to clear e3 if blank is chosen in the combo box