Calculation: Item changing

[kuzmi]

Hello,

I want to accomplish this to ease my reporting. Say I have these info;

Item Unit Price
A $10
B $20

If I were to do this;

Units Item Bulk Price
10 A
20 B

what can I do so that whenever I change the Item, the Bulk Price will also reflect the changes automatically (without having to add math functions in Bulk Price column manually).

Thanks.

kuzmi

[mangesh_yadav]

Lets say you have this info:
A $10
B $20
in cells A1:B2

And this:
10 A
20 B
in cells A11:B12

Then in cell C11, enter:
=VLOOKUP(B11,$A$1:$B$2,2)*A11
copy this to cell C12

- Mangesh

[kuzmi]

Hello,

I'm sorry Mangesh, I don't really get you. Maybe my explanation is rather vague in the first place. Anyway, did you mean;

Cell A1=A, Cell B1=B
Cell A2=10, Cell B2=20

and

Cell A11=10, Cell B11=A
Cell A12=20, Cell B12=B

and then I'm supposed to copy that formula in Cell C11?

Regards

kuzmi

[mangesh_yadav]

I am sorry if I was not clear enough. Infact I just used you example: So
A $10
B $20
in cells A1:B2
means...
A1=A, B1=10
A2=B, B2=20

And this:
10 A
20 B
in cells A11:B12
means...
A11=10, B11=A , in C11 enter =VLOOKUP(B11,$A$1:$B$2,2)*A11
A12=20, B12=B, in C12 enter =VLOOKUP(B12,$A$1:$B$2,2)*A12


- Mangesh

[kuzmi]

Now I get it. Thanx Mangesh.