SPECIAL LOOKUP FORMULA 4 MULTIPLE CRITERIA
 

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

SPECIAL LOOKUP FORMULA 4 MULTIPLE CRITERIA
 

You could use the GetPivotData function instead. There are examples in
Excel's Help, and he

http://www.contextures.com/xlPivot06.html

FARAZ QURESHI wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html