Forum Discussion
Dynamic Referencing Tables in Excell
Got an odd question that I'm not sure is even possible. I want to dynamically reference a table in order to look up values. I have a number of project trackers, each on their own sheet in a workboo...
That could be
=COUNTIF(INDIRECT($B$3 & "[Progress]"),0)
Hi Sergei, is this for Excel 2016/O365? I tried in Excel 2013, it won't work.
Hi Willy,
2016, but shall work in 2013. Please check attached.