Forum Discussion

crashkid1982's avatar
crashkid1982
Copper Contributor
Oct 31, 2023

“=“ 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,...
  • HansVogelaar's avatar
    Oct 31, 2023

    crashkid1982 

    In A1 on the Combine sheet:

     

    =LET(v, INDIRECT("'"&SELECT!$B$2&"'!A"&ROW()), IF(v="", "", v))

     

    Fill down.