How to apply a value in a cell based on the value of another

I want to use a specific number in a sum formula based on the data selected from a drop down list in another.

In column G is the drop down list with three values. The value selected affects the numeber used in this formula: =h2*# where the # is the numeric value associated with the item selected in column G.

Jane Doe = 10
John Smith = 15.2
Tom Jones = 18.75

What I'm hoping is for a way to automatically insert the formula with the correct value for "#" in column I.

Is that something I can accomplish?

You can set up a little table of those names and values (e.g. in Y1:Z3), Use Y1:Y3 as the source for your drop-down in G2, then you can have this formula in I2:

=IF(G2="","",H2*VLOOKUP(G2,$Y$1:$Z$3,2,0))

Hope this helps.

Pete

Originally Posted by Pete_UK

You can set up a little table of those names and values (e.g. in Y1:Z3), Use Y1:Y3 as the source for your drop-down in G2, then you can have this formula in I2:

=IF(G2="","",H2*VLOOKUP(G2,$Y$1:$Z$3,2,0))

Hope this helps.

Pete

Worked like a charm!

Thank you!!