Spreadsheet: 675038d1588111691-combined-vlookup-hlookup-hlookup-vlookup-example
Sheet: Crosstab by Prod

UPC | Article | RTE_DESSERTS_03X36_VALUMART | [NAME] | RTE_DESSERTS_04X24_ECONO_ONTARIO_WHOLESALE | RTE_DESSERTS_04X36_ATLANTIC_YIG | RTE_DESSERTS_04X36_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_04X36_MARKET_WEST | RTE_DESSERTS_04X36_ONTARIO_CITYMARKET | RTE_DESSERTS_04X36_ONTARIO_CITYMARKET_2663 | RTE_DESSERTS_04X36_QUEBEC_CITYMARKET | RTE_DESSERTS_04X36_QUEBEC_WHOLESALE | RTE_DESSERTS_04X72_EXTRAFOODS | RTE_DESSERTS_04X72X22_ONTARIO_NOFRILLS_URBAN | RTE_DESSERTS_04X78_ATLANTIC_YIG | RTE_DESSERTS_04X78_LOBLAWS_CITYMARKET | RTE_DESSERTS_04X78_MARKET_ATLANTIC | RTE_DESSERTS_04X78_MARKET_WEST | RTE_DESSERTS_04X78_PROVF | RTE_DESSERTS_04X78_VALUMART | RTE_DESSERTS_04X78_WEST_CITYMARKET | RTE_DESSERTS_04X84_ECONO_ATLANTIC_WHOLESALE | RTE_DESSERTS_04X84_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_04X84_ECONO_ONTARIO_WHOLESALE | RTE_DESSERTS_04X84_ECONO_WEST_NOFRILLS | RTE_DESSERTS_04X84_ECONO_WEST_WHOLESALE | [NAME] | RTE_DESSERTS_06X78_VALUMART | RTE_DESSERTS_06X84_ECONO_ATLANTIC_NOFRILLS | RTE_DESSERTS_06X84_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_06X84_ECONO_ONTARIO_WHOLESALE | RTE_DESSERTS_06X84_ECONO_QUEBEC_WHOLESALE | RTE_DESSERTS_06X84_ECONO_WEST_NOFRILLS | RTE_DESSERTS_08X24_ECONO_ATLANTIC_WHOLESALE | RTE_DESSERTS_08X24_ECONO_ONTARIO_WHOLESALE | RTE_DESSERTS_08X24_ECONO_WEST_WHOLESALE | RTE_DESSERTS_08X36_ECONO_WEST_WHOLESALE | RTE_DESSERTS_08X78_ATLANTIC_YIG | RTE_DESSERTS_08X78_LOBLAWS_1090 | RTE_DESSERTS_08X78_MARKET_ATLANTIC | RTE_DESSERTS_08X78_MARKET_ONTARIO | RTE_DESSERTS_08X78_MARKET_QUEBEC | RTE_DESSERTS_08X78_MARKET_WEST | [NAME] | RTE_DESSERTS_08X78_QUEBEC_WHOLESALE | RTE_DESSERTS_08X78_VALUMART | RTE_DESSERTS_08X78_WEST_WHOLESALE | [NAME] | RTE_DESSERTS_08X84_ECONO_ATLANTIC_WHOLESALE | RTE_DESSERTS_08X84_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_08X84_ECONO_ONTARIO_WHOLESALE | RTE_DESSERTS_08X84_ECONO_QUEBEC | RTE_DESSERTS_08X84_ECONO_QUEBEC_WHOLESALE | RTE_DESSERTS_08X84_ECONO_WEST_NOFRILLS | RTE_DESSERTS_08X84_ECONO_WEST_WHOLESALE | RTE_DESSERTS_08X84X18_ECONO_ONTARIO_NOFRILLS | [NAME] | RTE_DESSERTS_08X84X30_ECONO_ONTARIO_NOFRILLS_ALLSTARS | RTE_DESSERTS_10X84_ECONO_ATLANTIC_NOFRILLS | RTE_DESSERTS_10X84_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_10X84_ECONO_WEST_NOFRILLS | [NAME] | RTE_DESSERTS_10X84X30_ECONO_ONTARIO_NOFRILLS_ALLSTARS | RTE_DESSERTS_12X72_DISCOUNT_WEST | RTE_DESSERTS_12X72_EXTRAFOODS | RTE_DESSERTS_12X78_FORTINOS | RTE_DESSERTS_12X78_MARKET_ATLANTIC | [NAME] | RTE_DESSERTS_12X78_MARKET_QUEBEC | RTE_DESSERTS_12X78_MARKET_WEST | RTE_DESSERTS_12X78_PROVF | RTE_DESSERTS_12X78_WEST_WHOLESALE | RTE_DESSERTS_12X78X20_FORTINOS | RTE_DESSERTS_12X84_DISCOUNT_ONTARIO | [NAME] | RTE_DESSERTS_12X84_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_12X84_ECONO_QUEBEC | RTE_DESSERTS_12X84_ECONO_WEST_NOFRILLS | RTE_DESSERTS_12X84X18_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_12X84X30_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_12X84X30_ECONO_ONTARIO_NOFRILLS_ALLSTARS | [NAME] | [NAME] | RTE_DESSERTS_14X84X30_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_16X72_DISCOUNT_WEST | RTE_DESSERTS_16X72_EXTRAFOODS | RTE_DESSERTS_16X78_MARKET_ATLANTIC | RTE_DESSERTS_16X78_MARKET_ONTARIO | RTE_DESSERTS_16X78_MARKET_QUEBEC | RTE_DESSERTS_16X78_MARKET_WEST | RTE_DESSERTS_16X84_DISCOUNT_ONTARIO | [NAME] | RTE_DESSERTS_16X84_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_16X84_ECONO_QUEBEC | RTE_DESSERTS_16X84_ECONO_WEST_WHOLESALE | RTE_DESSERTS_16X84X30_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_20X72_DISCOUNT_WEST | RTE_DESSERTS_20X72_EXTRAFOODS | RTE_DESSERTS_20X78_MARKET_ATLANTIC | RTE_DESSERTS_20X78_MARKET_ONTARIO | RTE_DESSERTS_20X84_DISCOUNT_ONTARIO | RTE_DESSERTS_20X84_ECONO_QUEBEC | RTE_DESSERTS_24X72_DISCOUNT_WEST | RTE_DESSERTS_24X84_DISCOUNT_ONTARIO | RTE_DESSERTS_24X84_ECONO_QUEBEC | RTE_DESSERTS_28X72_DISCOUNT_WEST
 | AA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 1 | 2 | 2 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 |  |  |  | 3 |  |  | 2 | 1 | 2 | 2 |  | 3 | 2 |  | 3 | 3
 | AE |  |  |  |  |  |  |  |  |  |  | 2 |  | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 2 | 1 | 2 | 1 |  | 1 | 2 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 2 | 2 | 2 | 2 | 2 |  |  | 3 |  |  | 1 | 1 | 3 | 3 | 3 | 5 | 2 | 3 | 5 | 3
 | AD |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  | 1 | 2 | 2 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 2 | 2 | 2 | 2 | 1 | 2 |  | 2 | 2 |  |  | 1 |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 3 |  |  | 3 |  |  | 3 | 2 | 3 | 3 | 3 | 5 | 3 | 3 | 5 | 3
 | AC |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 |  |  |  | 1 | 1 |  | 2 |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 2 |  |  | 1 | 2 | 2 | 2 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 |  | 3 | 2 | 1 | 2 | 3 | 3 | 3 | 2 | 3 | 3 | 3
 | AB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 |  |  | 1
 | AF |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 2 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  | 2 | 2 | 1 | 2 | 2 | 1
 | AK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | AJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  | 1 | 2 | 2 | 1 |  | 2 | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | AG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  |  | 2 |  |  | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 1
 | AL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  | 2 |  |  | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 2 | 1