Get the first match cell contain in excel formula

[mehidy1437]

hi guys, I'm using the below formula to make a summery in my first sheet.

This formula is working nicely without any problem, but if there is an additional row with cell value "Total=", then it gives no result of that sheet.

I just want to add additional conditions in this formula to grab only the first match & ignore the rest if there is any row/cell with Total=.

Please help me with this.

FORMULA AT W32

=IFERROR(INDIRECT("'" & $V32 & "'!" &(ADDRESS(SUMPRODUCT((INDIRECT("'"&$V32&"'!$A$1:$AZ$1000")="Total=")*ROW($A$1:$A$1000)),(SUMPRODUCT((INDIRECT("'"&$V32&"'!$A$1:$AZ$1000")="Total=")*COLUMN($A$1:$AZ$1)))+21))),"")

 

[mehidy1437]

Thanks a lot, @jasonb75
I will keep this in mind.