I have a below formula
Containing two sheets Balance Payable & Outstanding
if Balance Payable column "L" contains no data then getting error message "#N/A" ( Workbook attached for your ready reference.)
{=INDEX('Balance Payable'!L:L,MATCH(1,(Outstanding!A2='Balance Payable'!I:I)*(B2='Balance Payable'!J:J),0))}
Any suggestion help would be greatly appreciated.
Regards
Sagar007
Bookmarks