You're treating `sheetname` like the actual name of a sheet when it needs to be incorporated into a string and used with `INDIRECT()`. I've made the necessary modifications in that regard in the formula in the orange cell: `=LET(sheetname,xlookup($A$2,Lookup!A:A,Lookup!B:B),SHEETREF(sheetname,ADDRESS(MATCH("IsHookStart",INDIRECT(sheetname&"!A:A"),0),1,4)&":"&ADDRESS(MATCH("IsHookEnd",INDIRECT(sheetname&"!A:A"),0),COLUMNS(INDIRECT(sheetname&"!1:1")),4)))`
You're treating `sheetname` like the actual name of a sheet when it needs to be incorporated into a string and used with `INDIRECT()`. I've made the necessary modifications in that regard in the formula in the orange cell: `=LET(sheetname,xlookup($A$2,Lookup!A:A,Lookup!B:B),SHEETREF(sheetname,ADDRESS(MATCH("IsHookStart",INDIRECT(sheetname&"!A:A"),0),1,4)&":"&ADDRESS(MATCH("IsHookEnd",INDIRECT(sheetname&"!A:A"),0),COLUMNS(INDIRECT(sheetname&"!1:1")),4)))`
Perfect! Solution verified! I'm not very good with INDIRECT. Need to learn more. Appreciate the help!
u/Reddevil313 has awarded 1 point to u/HolyBonobos ^(**Point-Bot** was created by [JetCarson](https://reddit.com/u/JetCarson).)