You can do something like this with an INDEX(MATCH(MATCH formula:
| A | B | C | D | E |
|---|
| Quantity | Price | Total Cost | | | |
| Pears | | | | | |
| Apples | | | | | |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]1/31/2017[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]11.25[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]1/31/2017[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]0.34[/TD]
[TD="align: right"]11.56[/TD]
</tbody>
Sheet1
[TABLE="width: 85%"]
<tbody>[TR]
[TD]
Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D2[/TH]
[TD="align: left"]=INDEX(
Sheet2!$B$6:$C$11,MATCH(A2,Sheet2!$A$6:$A$11),MATCH(B2,Sheet2!$B$1:$C$1,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E2[/TH]
[TD="align: left"]=C2*D2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
It did help when you created the table, as opposed to trying to post images. For future reference, look at the HTML Maker in my signature, which allows you to post a screen print like I did.
Hope this helps!
