Hi,
I am having a hard time with the syntax for indirect.
(IF($L$4="All",1,Table1[Type] =$L$4))
In my setup G40 holds a sheet name and $L$4 are a specific value located in the sheet which G40 holds. I need a way to place indirect around both L4's so that it has the sheet reference behind it.
Any help would be amazing.
Bookmarks