If question

[Tazzbjs]

I know this is simple IF solution, but haven't had to us it in a long time. I need a formula to pull the unit price from another sheet in the same workbook, based on column B and C. I have a tab in my workbook called Product List. It has Size in Column A, Discrition in Colomn B and total item price in Column E. Any help is greatly appreciated.

	A	B	C	D	E
12	QTY	SIZE	DISCRIPTION	UNIT PRICE	TOTAL
13	3	XL	Mens Shirt LS		0.00
14	3	XL	Mens Shirt SS
15

<tbody>
</tbody>

​

 

[Eric W]

You could use a SUMIFS. Try in D13:

=SUMIFS(Sheet2!$E:$E,Sheet2!$A:$A,B13,Sheet2!$B:$B,C13)

The E13 formula is simply:

=D13*A13