Creating items list with corresponding prices

  • Thread starter Thread starter Excel Help
  • Start date Start date
E

Excel Help

I have created a list of items and each item has a corresponding price. Can
I make the correspoing price correlate with which item I choose from the list?

So For example I have four items, called item #1, Item #2, Item #3 & Item
#4.

If I choose item #1 for $10.00 could I make $10.00 display in a cell when
item #1 is chosen. And if I chose another item the dollar amount would
change?
 
Hi,
When you talk about "choosing an item", do you mean from a drop-down list?
If so, then it would be easy to bring up the price in the adjacent cell,
using VLOOKUP.
Regards - Dave.
 
Suppose you have a 2 column table like this:

...........A..........B
1.....Item1......10
2.....Item2......7
3.....Item3......12
4.....Item4......17

Then you enter some item in cell D1:

D1 = item3

Enter this formula in E1 to get the price:

=SUMIF(A1:A4,D1,B1:B4)
 
Hi,

If you enter a list in C1:D4 with the items in column C and the item you
pick in A1 then

=LOOKUP(A1,C1:D4)

So infact there are many ways to do this.
 
=LOOKUP(A1,C1:D4)

Using this formula would require the item list to be sorted in ascending
order.
 
Hi,

Technically you could also use
=DSUM(Data,Col,Crit)
but this requires a criteria range and the item must appear only once or
else it will return the sum of the items.

In 2007 you could use
=SUMIFS
but like the formula above this require that each item appear only once

But if each item appears only once you could use
AVERAGEIF
AVERAGIFS
SUMPRODUCT
MAX(IF... (these being arrays)
MIN(IF... "
and on and on....
 
ColA ColB
Item1 10
Item2 20
Item3 30
Item4 40

C1 = "Item1"
D1 = INDEX(B:B,MATCH(C1,A:A))

If this post helps click Yes
 
Back
Top