Conditional Formulas - How do I make quantity of a cell change the value of other cells?

[johnny_rockets]

Hi,

I'm really new to this spreadsheet stuff and I can't seem to find a simple answer to this question...

How do I make a cell change to another cell's value based on the value of a third cell?

That's a confusing way to ask, perhaps. I have quantities (1-12) and different dollar amounts for each. So, if i were to enter '3' as a quantity in column A, I would want column B to display $3 and so on.

[TABLE="width: 448"]
<colgroup><col style="width:48pt" span="7" width="64"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]VENDOR 1[/TD]
[TD="class: xl64, width: 64"]TOTAL[/TD]
[TD="class: xl73, width: 64"]VENDOR 2
[/TD]
[TD="class: xl64, width: 64"]TOTAL[/TD]
[TD="class: xl65, width: 64"]VENDOR 3
[/TD]
[TD="class: xl64, width: 64"]TOTAL[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]1[/TD]
[TD="class: xl68"]$1.00[/TD]
[TD="class: xl67"]3[/TD]
[TD="class: xl68"]$4.00[/TD]
[TD="class: xl67"]5[/TD]
[TD="class: xl68"]$7.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1[/TD]
[TD="class: xl72, align: right"]$1 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$2 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$3 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]2[/TD]
[TD="class: xl72, align: right"]$2 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$3 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$4 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]3[/TD]
[TD="class: xl72, align: right"]$3 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$4 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$5 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]4[/TD]
[TD="class: xl72, align: right"]$4 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$5 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$6 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]5[/TD]
[TD="class: xl72, align: right"]$5 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$6 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$7 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]6[/TD]
[TD="class: xl72, align: right"]$6 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$7 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$8 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]7[/TD]
[TD="class: xl72, align: right"]$7 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$8 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$9 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]8[/TD]
[TD="class: xl72, align: right"]$8 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$9 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$10 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]9[/TD]
[TD="class: xl72, align: right"]$9 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$10 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$11 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]10[/TD]
[TD="class: xl72, align: right"]$10 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$11 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$12 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]11[/TD]
[TD="class: xl72, align: right"]$11 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$12 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$13 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]12[/TD]
[TD="class: xl72, align: right"]$12 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$13 [/TD]
[TD][/TD]
[TD="class: xl72, align: right"]$14 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Any help would be greatly appreciated.

THANKS!

 

[ChrisR]

Hi,

The data you have posted is a little unclear, which is why I think you haven't had any responses yet.........

Can you either post in the correct format or try to re-iterate what you need? With exact cell references etc so that I can understand better what you need?

I think what you are asking for is easy enough, I'm just not sure exactly what you are looking for!

Cheers
Chris

 

[Andrew Poulsom]

In B2 enter:

=VLOOKUP(A2,$A3:B14,COLUMNS($A3:B14))

and copy it to D2 and F2. You may need to change the row references in the lookup range $A3:B14.

 

[johnny_rockets]

Thanks, guys!

I got an answer on a different forum.

It was essentially what Andrew said.