Forum Discussion
“=“ pull data from different tabs
Hi there. I would like to build a cross-reference to different(!) (selectable via dropdown) tabs in a single file. Column A in the tab “COMBINE” should distribute linked values via “=A1,...
In A1 on the Combine sheet:
=LET(v, INDIRECT("'"&SELECT!$B$2&"'!A"&ROW()), IF(v="", "", v))
Fill down.
In A1 on the Combine sheet:
=LET(v, INDIRECT("'"&SELECT!$B$2&"'!A"&ROW()), IF(v="", "", v))
Fill down.
- THANK YOU!!! That is exactly what I was looking for!!
