crashkid1982
Oct 31, 2023Copper Contributor
“=“ 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,...
- Oct 31, 2023
In A1 on the Combine sheet:
=LET(v, INDIRECT("'"&SELECT!$B$2&"'!A"&ROW()), IF(v="", "", v))
Fill down.