Hi,
I'm struggling to pull data out of a filtered table via the Index function.
I have tried to follow the examples provided in similar posts but failing - please help.
Basically I want to filter on "SD Theme", column L.
Then using my "Designator" in column B populate the 'action tracker' tab. The arrangement in 'action tracker' will then be copied to powerpoint to present the overall status.
I use some helper cells to position the graphs on the final slide and so my formula (without attempting to just read visible cells) is =IFERROR(INDEX(T.Data[Designator],B$2+4*($A5-1)),"")
Thank you for your help!
Bookmarks