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.

VENDOR 1	TOTAL	VENDOR 2	TOTAL	VENDOR 3	TOTAL
1	$1.00	3	$4.00	5	$7.00
1	$1		$2		$3
2	$2		$3		$4
3	$3		$4		$5
4	$4		$5		$6
5	$5		$6		$7
6	$6		$7		$8
7	$7		$8		$9
8	$8		$9		$10
9	$9		$10		$11
10	$10		$11		$12
11	$11		$12		$13
12	$12		$13		$14

<colgroup><col style="width:48pt" span="7" width="64"> </colgroup><tbody>
</tbody>

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.