INDEX MATCH Getting error (2)

**sagar007** · 10-30-2012, 06:14 AM

Hello Friends

Sorry to come here again & again

i have a below formula

{=IFERROR(INDEX('Balance Payable'!L:L,MATCH(1,(Outstanding!A3='Balance Payable'!I:I)*(B3='Balance Payable'!J:J),0)),0)}

I am trying to get data in to Column E of Sheets "Outstanding" form pivot table contains on "Balance Payable" Sheets. For Further Details please see attached workbook

For Example :
in pivot table (sheet "Balance Payable") column "I5" contains no data & column "J5" & "K5" contains data then value display 0 in to Column E of Sheets "Outstanding". & I want to get data if "I5" contains no data & J5 & K5 has data then display value of column L in to the Column E of Sheets "Outstanding"
PT.jpg

Any help / suggestion would be greatly appreciated.

Regards
Sagar007

PT.jpg

**:) Sixthsense :)** · 10-30-2012, 06:30 AM

Originally Posted by sagar007

For Example :
in pivot table (sheet "Balance Payable") column "I5" contains no data & column "J5" & "K5" contains data then value display 0 in to Column E of Sheets "Outstanding". & I want to get data if "I5" contains no data & J5 & K5 has data then display value of column L in to the Column E of Sheets "Outstanding"

The supplier name is not getting repeated in I5 to I7, since it is a pivot. so the formula is failing to identify the data.

**sagar007** · 10-30-2012, 06:39 AM

Thank you for your reply, but how to solve this or what is the solution?

**:) Sixthsense :)** · 10-31-2012, 12:32 AM

I believe that the Invoice # wont be common for the customers, so instead of trying to include the Supplier Name in your formula you can just compare the invoice no and get the expected data.

Hope this helps!