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.
Bookmarks