There are 3 Sheets in this file:"Mapping", "Data", and "Pivot"
1st Sheet is "Mapping"
[TABLE="width: 2786"]
<tbody>[TR]
[TD]Level[/TD]
[TD]Name[/TD]
[TD]Name Sector ID[/TD]
[TD]Company Sector ID[/TD]
[TD]Sector[/TD]
[TD]Applicability ID[/TD]
[TD]Link[/TD]
[TD]Link Name[/TD]
[TD]Solution Name[/TD]
[TD]Mapping 1[/TD]
[TD]Mapping 1 Revenue[/TD]
[TD]Mapping 2[/TD]
[TD]Mapping 2 Revenue[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dairy Farms[/TD]
[TD]43523[/TD]
[TD]D43523[/TD]
[TD]Dairy[/TD]
[TD]D43523Dairy[/TD]
[TD](blank)[/TD]
[TD]01-Dairy[/TD]
[TD]43523:airy[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dairy Farms[/TD]
[TD]52236[/TD]
[TD]D52236[/TD]
[TD]Dairy[/TD]
[TD]D52236Dairy[/TD]
[TD](blank)[/TD]
[TD]01-Dairy[/TD]
[TD]52236:airy[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dairy Farms[/TD]
[TD]74245[/TD]
[TD]D74245[/TD]
[TD]Dairy[/TD]
[TD]D74245Dairy[/TD]
[TD](blank)[/TD]
[TD]01-Dairy[/TD]
[TD]74245:airy[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Burger Deluxe[/TD]
[TD]27434[/TD]
[TD]B27434[/TD]
[TD]Burger[/TD]
[TD]B27434Burger[/TD]
[TD](blank)[/TD]
[TD]01-Burger[/TD]
[TD]27434:urger[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Burger Deluxe[/TD]
[TD]97537[/TD]
[TD]B97537[/TD]
[TD]Burger[/TD]
[TD]B97537Burger[/TD]
[TD](blank)[/TD]
[TD]01-Burger[/TD]
[TD]97537:urger[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Chicken Dreams[/TD]
[TD]35786[/TD]
[TD]C35786[/TD]
[TD]Chicken[/TD]
[TD]C35786Chicken[/TD]
[TD](blank)[/TD]
[TD]01-Chicken[/TD]
[TD]35786:hicken[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Chicken Dreams[/TD]
[TD]85357[/TD]
[TD]C85357[/TD]
[TD]Chicken[/TD]
[TD]C85357Chicken[/TD]
[TD](blank)[/TD]
[TD]01-Chicken[/TD]
[TD]85357:hicken[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Chicken Dreams[/TD]
[TD]38535[/TD]
[TD]C38535[/TD]
[TD]Chicken[/TD]
[TD]C38535Chicken[/TD]
[TD](blank)[/TD]
[TD]01-Chicken[/TD]
[TD]38535:hicken[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
2nd Sheet is "Data"
[TABLE="width: 4177"]
<tbody>[TR]
[TD]Country[/TD]
[TD]CountryZone[/TD]
[TD]ExColumn1[/TD]
[TD]ExColumn2[/TD]
[TD]ExColumn3[/TD]
[TD]ExColumn4[/TD]
[TD]ExColumn5[/TD]
[TD]Sector[/TD]
[TD]ExColumn6[/TD]
[TD]ExColumn7[/TD]
[TD]ExColumn8[/TD]
[TD]ExColumn9[/TD]
[TD]ExColumn10[/TD]
[TD]ExColumn11[/TD]
[TD]ExColumn12[/TD]
[TD]ExColumn13[/TD]
[TD]Product Id[/TD]
[TD]ExColumn14[/TD]
[TD]ExColumn15[/TD]
[TD]ExColumn16[/TD]
[TD]ExColumn17[/TD]
[TD]Revenue[/TD]
[TD]Records[/TD]
[TD]Domain[/TD]
[TD]Domain Sub 1[/TD]
[TD]Domain Sub 2[/TD]
[TD]Domain Sub 3[/TD]
[TD]Domain Sub 4[/TD]
[TD]Domain Sub 5[/TD]
[TD]Domain Sub 6[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]USA1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2435[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$25[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]USA2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2435[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$345[/TD]
[TD="align: right"]2[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]USA3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2436[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$62[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]USA4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Burger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2436[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$872[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Burger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2436[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$35[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2437[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$375[/TD]
[TD="align: right"]2[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2437[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$26[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2437[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$73[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2438[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$84[/TD]
[TD="align: right"]4[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2438[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$97[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Germany1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2438[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$58[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Germany2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Burger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2439[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$12[/TD]
[TD="align: right"]4[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Germany3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Burger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2439[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$42[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Germany4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2439[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$26[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]France1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2440[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$73[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]France2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2440[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$57[/TD]
[TD="align: right"]5[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]France3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2440[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$84[/TD]
[TD="align: right"]4[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]France4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2441[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$34[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]France5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2441[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$84[/TD]
[TD="align: right"]1[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
</tbody>[/TABLE]
The 3rd Sheet is the Pivot Table created from the "Data" Sheet
[TABLE="width: 411"]
<tbody>[TR]
[TD]Sum of Revenue[/TD]
[TD]Column Labels[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD] Burger[/TD]
[TD]Chicken[/TD]
[TD]Dairy[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.2[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.2.0[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.2.0.0[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.2.0.0.0[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.2.0.0.0.0[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4.3[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4.3.0[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4.3.0.0[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4.3.0.0.0[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4.3.0.0.0.0[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]961[/TD]
[TD="align: right"]630[/TD]
[TD="align: right"]873[/TD]
[TD="align: right"]2464[/TD]
[/TR]
</tbody>[/TABLE]
Look at Sheet 1 in row K "Mapping 1 Revenue". I want to create a formula that takes the Column E "Sector" and Column J "Mapping 1" and searches for it in the Pivot Table. I want to find the Mapping 1 revenue based on Sector and Mapping ID and I need a formula that searches the pivot table based on that same column and row. If there are any other questions I can answer, please let me know. Thank you in advance for the help!
1st Sheet is "Mapping"
[TABLE="width: 2786"]
<tbody>[TR]
[TD]Level[/TD]
[TD]Name[/TD]
[TD]Name Sector ID[/TD]
[TD]Company Sector ID[/TD]
[TD]Sector[/TD]
[TD]Applicability ID[/TD]
[TD]Link[/TD]
[TD]Link Name[/TD]
[TD]Solution Name[/TD]
[TD]Mapping 1[/TD]
[TD]Mapping 1 Revenue[/TD]
[TD]Mapping 2[/TD]
[TD]Mapping 2 Revenue[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dairy Farms[/TD]
[TD]43523[/TD]
[TD]D43523[/TD]
[TD]Dairy[/TD]
[TD]D43523Dairy[/TD]
[TD](blank)[/TD]
[TD]01-Dairy[/TD]
[TD]43523:airy[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dairy Farms[/TD]
[TD]52236[/TD]
[TD]D52236[/TD]
[TD]Dairy[/TD]
[TD]D52236Dairy[/TD]
[TD](blank)[/TD]
[TD]01-Dairy[/TD]
[TD]52236:airy[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dairy Farms[/TD]
[TD]74245[/TD]
[TD]D74245[/TD]
[TD]Dairy[/TD]
[TD]D74245Dairy[/TD]
[TD](blank)[/TD]
[TD]01-Dairy[/TD]
[TD]74245:airy[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Burger Deluxe[/TD]
[TD]27434[/TD]
[TD]B27434[/TD]
[TD]Burger[/TD]
[TD]B27434Burger[/TD]
[TD](blank)[/TD]
[TD]01-Burger[/TD]
[TD]27434:urger[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Burger Deluxe[/TD]
[TD]97537[/TD]
[TD]B97537[/TD]
[TD]Burger[/TD]
[TD]B97537Burger[/TD]
[TD](blank)[/TD]
[TD]01-Burger[/TD]
[TD]97537:urger[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Chicken Dreams[/TD]
[TD]35786[/TD]
[TD]C35786[/TD]
[TD]Chicken[/TD]
[TD]C35786Chicken[/TD]
[TD](blank)[/TD]
[TD]01-Chicken[/TD]
[TD]35786:hicken[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Chicken Dreams[/TD]
[TD]85357[/TD]
[TD]C85357[/TD]
[TD]Chicken[/TD]
[TD]C85357Chicken[/TD]
[TD](blank)[/TD]
[TD]01-Chicken[/TD]
[TD]85357:hicken[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Chicken Dreams[/TD]
[TD]38535[/TD]
[TD]C38535[/TD]
[TD]Chicken[/TD]
[TD]C38535Chicken[/TD]
[TD](blank)[/TD]
[TD]01-Chicken[/TD]
[TD]38535:hicken[/TD]
[TD]'C4.2.0.0.0.0[/TD]
[TD][/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
2nd Sheet is "Data"
[TABLE="width: 4177"]
<tbody>[TR]
[TD]Country[/TD]
[TD]CountryZone[/TD]
[TD]ExColumn1[/TD]
[TD]ExColumn2[/TD]
[TD]ExColumn3[/TD]
[TD]ExColumn4[/TD]
[TD]ExColumn5[/TD]
[TD]Sector[/TD]
[TD]ExColumn6[/TD]
[TD]ExColumn7[/TD]
[TD]ExColumn8[/TD]
[TD]ExColumn9[/TD]
[TD]ExColumn10[/TD]
[TD]ExColumn11[/TD]
[TD]ExColumn12[/TD]
[TD]ExColumn13[/TD]
[TD]Product Id[/TD]
[TD]ExColumn14[/TD]
[TD]ExColumn15[/TD]
[TD]ExColumn16[/TD]
[TD]ExColumn17[/TD]
[TD]Revenue[/TD]
[TD]Records[/TD]
[TD]Domain[/TD]
[TD]Domain Sub 1[/TD]
[TD]Domain Sub 2[/TD]
[TD]Domain Sub 3[/TD]
[TD]Domain Sub 4[/TD]
[TD]Domain Sub 5[/TD]
[TD]Domain Sub 6[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]USA1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2435[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$25[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]USA2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2435[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$345[/TD]
[TD="align: right"]2[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]USA3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2436[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$62[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]USA4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Burger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2436[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$872[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Burger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2436[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$35[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2437[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$375[/TD]
[TD="align: right"]2[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2437[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$26[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2437[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$73[/TD]
[TD="align: right"]1[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2438[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$84[/TD]
[TD="align: right"]4[/TD]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD]C4[/TD]
[TD]C4.2[/TD]
[TD]C4.2.0[/TD]
[TD]C4.2.0.0[/TD]
[TD]C4.2.0.0.0[/TD]
[TD]C4.2.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]Italy6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2438[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$97[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Germany1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2438[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$58[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Germany2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Burger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2439[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$12[/TD]
[TD="align: right"]4[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Germany3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Burger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2439[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$42[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Germany4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2439[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$26[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]France1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2440[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$73[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]France2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2440[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$57[/TD]
[TD="align: right"]5[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]France3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2440[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$84[/TD]
[TD="align: right"]4[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]France4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T2441[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$34[/TD]
[TD="align: right"]2[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]France5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dairy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D2441[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$84[/TD]
[TD="align: right"]1[/TD]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD]C4[/TD]
[TD]C4.3[/TD]
[TD]C4.3.0[/TD]
[TD]C4.3.0.0[/TD]
[TD]C4.3.0.0.0[/TD]
[TD]C4.3.0.0.0.0[/TD]
[/TR]
</tbody>[/TABLE]
The 3rd Sheet is the Pivot Table created from the "Data" Sheet
[TABLE="width: 411"]
<tbody>[TR]
[TD]Sum of Revenue[/TD]
[TD]Column Labels[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD] Burger[/TD]
[TD]Chicken[/TD]
[TD]Dairy[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD]C4.2.0.0.0.0:ICE[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.2[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.2.0[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.2.0.0[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.2.0.0.0[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.2.0.0.0.0[/TD]
[TD="align: right"]907[/TD]
[TD="align: right"]474[/TD]
[TD="align: right"]516[/TD]
[TD="align: right"]1897[/TD]
[/TR]
[TR]
[TD]C4.3.0.0.0.0:TEST[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4.3[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4.3.0[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4.3.0.0[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4.3.0.0.0[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]C4.3.0.0.0.0[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]357[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]961[/TD]
[TD="align: right"]630[/TD]
[TD="align: right"]873[/TD]
[TD="align: right"]2464[/TD]
[/TR]
</tbody>[/TABLE]
Look at Sheet 1 in row K "Mapping 1 Revenue". I want to create a formula that takes the Column E "Sector" and Column J "Mapping 1" and searches for it in the Pivot Table. I want to find the Mapping 1 revenue based on Sector and Mapping ID and I need a formula that searches the pivot table based on that same column and row. If there are any other questions I can answer, please let me know. Thank you in advance for the help!
