Currently I am working on a document in google sheets with several tabs.
"SS", "Math", "Sci", ...
and I have a formula I am working on in a separate tab....
=iferror(if(A2="","",index(SS!D:D,match(A2&$B$1,SS!E:E&SS!G:G,0))))
^
I am wondering if the "SS!D:D" piece can be modified to include column D from ALL the tabs, not just SS.
I hope that makes sense.
"SS", "Math", "Sci", ...
and I have a formula I am working on in a separate tab....
=iferror(if(A2="","",index(SS!D:D,match(A2&$B$1,SS!E:E&SS!G:G,0))))
^
I am wondering if the "SS!D:D" piece can be modified to include column D from ALL the tabs, not just SS.
I hope that makes sense.
