F
FARAZ QURESHI
Hi every1,
I have a pivot table with data in the following format:
Branch 1 Branch 2
Product A Product B Product C Product A Product B
Product C
Region I
Region II
Region III
Now on another sheet I want to link the pivot data with some lookup formula
in the following manner:
Branch 1 Branch 2
Region I
Product A ?
Product B
Product C
Region II
Product A
Product B
Product C
Region III
Product A
Product B
Product C
The formula should use HLOOKUP for Branch 1, then again for Product A and
join the same with some sort of VLOOKUP or MATCH function with Region I and
return the corresponding figure.
Lets assume the Pivot Table is starting from the very first cell, i.e. A1,
therefore the target cell in this case being B3.
Thanx in Advance!
FARAZ
I have a pivot table with data in the following format:
Branch 1 Branch 2
Product A Product B Product C Product A Product B
Product C
Region I
Region II
Region III
Now on another sheet I want to link the pivot data with some lookup formula
in the following manner:
Branch 1 Branch 2
Region I
Product A ?
Product B
Product C
Region II
Product A
Product B
Product C
Region III
Product A
Product B
Product C
The formula should use HLOOKUP for Branch 1, then again for Product A and
join the same with some sort of VLOOKUP or MATCH function with Region I and
return the corresponding figure.
Lets assume the Pivot Table is starting from the very first cell, i.e. A1,
therefore the target cell in this case being B3.
Thanx in Advance!
FARAZ