help with formula

[Chicks Rule]

Hi,

I have a list of products (column A) with corresponding prices in a second column (column B).

What I am trying to achieve, is that if create a list of products in data validation- then select particular product from column A, then in column B the price should automatically appear relating to the product that I have selected.

Any suggestion?????

 

[shg]

You can use a VLOOKUP formula. See http://www.contextures.com/xlfunctions02.html

 

[T. Valko]

Hi,

I have a list of products (column A) with corresponding prices in a second column (column B).

What I am trying to achieve, is that if create a list of products in data validation- then select particular product from column A, then in column B the price should automatically appear relating to the product that I have selected.

Any suggestion?????

One way...

Book1
	A	B	C	D	E
1	Product	Price	_	Product	Price
2	Product1	86	_	Product4	84
3	Product2	41	_	_	_
4	Product3	14	_	_	_
5	Product4	84	_	_	_
6	Product5	88	_	_	_
7	Product6	94	_	_	_
8	Product7	77	_	_	_
9	Product8	30	_	_	_
10	Product9	4	_	_	_
Sheet2

Formula entered in E2:

=SUMIF(A2:A10,D2,B2:B10)

 

[shg]

That's an odd use of SUMIF, Biff.

 

[T. Valko]

That's an odd use of SUMIF, Biff.

Not really.

It's just 1 of about 5 or 6 ways to do what the OP wants.

 

[shg]

It seems to me that if the same product appears multiple times on the price list, it's unlikely that the correct price is the sum of the prices.

 

[T. Valko]

It seems to me that if the same product appears multiple times on the price list, it's unlikely that the correct price is the sum of the prices.

I can't think of a good reason why a price list would have multiple instances of the same product.

How about we wait to hear back from the OP to see if that's a possibility?