Two way lookup - Text and Number

[thegreencar]

Hi I'm trying to write a formula to solve for the below, where the Item and Quota are given and the multiplier is needed.
Tried doing a sumifs with True lookup back can't get it to work.

Any help is greatly appreciated.

Item Quota <tbody> [TD="class: xl66, width: 76"]Multiplier1
<tbody> [TD="class: xl66"]Item
Thanks,
<tbody> [TD="class: xl67"]

<tbody>

apples

apples

apples

Pears

Pears

Pears

Oranges

Oranges

Oranges

[TD="class: xl66, width: 76"]Multiplier2[/TD]
[TD="class: xl66, width: 76"]Multiplier3[/TD]

[TD="align: right"]20[/TD]
[TD="class: xl67, align: right"]1.05[/TD]
[TD="class: xl67, align: right"]1.10[/TD]
[TD="class: xl67, align: right"]2.00[/TD]

[TD="align: right"]40[/TD]
[TD="class: xl67, align: right"]1.25[/TD]
[TD="class: xl67, align: right"]2.00[/TD]
[TD="class: xl67, align: right"]0.00[/TD]

[TD="align: right"]60[/TD]
[TD="class: xl67, align: right"]1.25[/TD]
[TD="class: xl67, align: right"]2.00[/TD]
[TD="class: xl67, align: right"]0.00[/TD]

[TD="align: right"]10[/TD]
[TD="class: xl67, align: right"]1.10[/TD]
[TD="class: xl67, align: right"]1.20[/TD]
[TD="class: xl67, align: right"]2.00[/TD]

[TD="align: right"]20[/TD]
[TD="class: xl67, align: right"]1.15[/TD]
[TD="class: xl68, align: right"]1.70[/TD]
[TD="class: xl68, align: right"]2.50[/TD]

[TD="align: right"]30[/TD]
[TD="class: xl68, align: right"]1.65[/TD]
[TD="class: xl68, align: right"]2.20[/TD]
[TD="class: xl68, align: right"]3.00[/TD]

[TD="align: right"]50[/TD]
[TD="class: xl67, align: right"]1.05[/TD]
[TD="class: xl67, align: right"]1.10[/TD]
[TD="class: xl67, align: right"]2.00[/TD]

[TD="align: right"]100[/TD]
[TD="class: xl68, align: right"]1.10[/TD]
[TD="class: xl68, align: right"]1.15[/TD]
[TD="class: xl68, align: right"]2.05[/TD]

[TD="align: right"]250[/TD]
[TD="class: xl68, align: right"]1.15[/TD]
[TD="class: xl68, align: right"]1.20[/TD]
[TD="class: xl68, align: right"]2.10[/TD]

</tbody>

[/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]

[TD="class: xl67"]Quota[/TD]
[TD="class: xl68, width: 76"] Multiplier1
[/TD]
[TD="class: xl68, width: 76"] Multiplier2 [/TD]
[TD="class: xl68, width: 76"] Multiplier3 [/TD]

[TD="class: xl69"]apples[/TD]
[TD="class: xl70, align: center"]60[/TD]
[TD="class: xl71"] Formula [/TD]
[TD="class: xl71"] Formula [/TD]
[TD="class: xl71"] Formula [/TD]

</tbody>

[/TD]
[TD="align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]

[TD="align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]

[TD="align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]

[TD="align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]

[TD="align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="align: right"][/TD]
[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]

[TD="align: right"][/TD]
[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="align: right"][/TD]
[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl68"][/TD]
[TD="class: xl68, width: 76"][/TD]
[TD="class: xl68, width: 76"][/TD]

[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]

</tbody>

[/TD]

[TD="class: xl71"][/TD]

[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]

</tbody>

 

[AlanY]

you're welcome