Hi,
I am trying to pull info from two lists (each located in a different tab) into a third tab. The two lists might get additional names in the future and I want to fireproof the formula to pull in any additional data that might be later on added in the 2 tabs. I am having a hard time coming up with a formula...
I did something like if(isblank(tab1$A1),tab2$A1,tab1A1) but bc I can't anchor the cells it obviously doesn't work.
Could you be so kind to help?
Thank you.
I am trying to pull info from two lists (each located in a different tab) into a third tab. The two lists might get additional names in the future and I want to fireproof the formula to pull in any additional data that might be later on added in the 2 tabs. I am having a hard time coming up with a formula...
I did something like if(isblank(tab1$A1),tab2$A1,tab1A1) but bc I can't anchor the cells it obviously doesn't work.
Could you be so kind to help?
Thank you.