You will have to consider another approach.
The following example should fit your needs:
http://cjoint.com/?dwtb7HTh8d

HTH
--
AP

a écrit dans le message de
oups.com...
thank you for the help. it does help, for a second sheet I am
doing...however I made a mistake when posting, and I gave some wrong
info. Here is the actual question that I meant to write. Here is my
sheet
A B C D E F
G
1 x xx xxx xxxx
xxxxx
2 Tom =b2 =B2*2.2 =b2*3.1 =b2*9 =b2*2

3 Bill =b3 =B3*2.4 =b3*3.2 =b3*8
=b3*4
4 Steve =b4 =B4*2.12 =b4*6.4 =b4*1 =b4*5
5 Harry =b5 =B5*1.94 =b5*5 =b5*1 =b5*2
6 John =b6 =B6*2.6 =b6*2 =b6*2
=b6*6

In the above example, I put a # in b and it multiplies it by the # in
the formula (obviously)
I have a drop down menu of the 5 names, and a drop down menu of the x,
xx, xxx, xxxx, xxxxx. I basically want to put a box in between these
cells where I can type in a # and it would display the result in the
4th box..like below (the NAME, #, X?, result are the column labels)

NAME # X?
Result
(drop down ) (enter manually) (drop down) ***
***would take the formula from the sheet above, and put the end result
here.
IF you can help I would greatly appreciate it, or if you know of a
better way to do this, it would be great as well. Thank you so much in
advance,
Scott