Is there a way to use BYROW and search multiple tabs for a match via an INDIRECT:INDIRECT array?

[jrhouse5]

Is there a way to make something like this work in excel (for example, find the row for a Cost Category on each Project Tab with timeseries data):

=BYROW(Tab_Names_by_Project, LAMBDA(r, MATCH(Cost_Category, INDIRECT(ADDRESS(1,Column_Number,,,r)):INDIRECT(ADDRESS(1000,ColumnNumber,,,r)), 0)))

This formula results in #VALUE! errors.

 

[Domenic]

Is this what you mean?

=BYROW(Tab_Names_by_Project,LAMBDA(r,MATCH(Cost_Category,INDIRECT("'"&r&"'!"&ADDRESS(1,Column_Number)&":"&ADDRESS(1000,Column_Number)),0)))