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.



[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]QTY[/TD]
[TD="align: center"]SIZE[/TD]
[TD="align: center"]DISCRIPTION[/TD]
[TD="align: center"]UNIT PRICE[/TD]
[TD="align: center"]TOTAL[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]XL[/TD]
[TD="align: center"]Mens Shirt LS[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0.00[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]XL[/TD]
[TD="align: center"]Mens Shirt SS[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

​

 

[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