Hi guys,
I'm new here but I did try and look for a similar issue before I went ahead and posted this. I apologise if I missed anything that relates to this.
I'm trying to create a worksheet that automatically updates and builds a list based on data in other worksheets.
To explain, I have 10+ tabs. One tab is labled as "Master list" and the other 9 are individual teams in the company I work for. Is there a way I can creat a formula that will dynamically lookup the values of each team and stack them in the master list? I was thinking something like a vlookup and iserror mix. That would look something like
=IF(ISERROR(VLOOKUP(B36,'Master Contact list.xlsx'!team1,3,FALSE)),VLOOKUP(B36,'Master Contact list.xlsx'!team2,3,FALSE)),VLOOKUP(B36,'Master Contact list.xlsx'!team1,3,FALSE)),
or something equally wordy. The only problem with using IF is there's only a possible two answers.
All the teams in other worksheets are named ranges - will this help?
The more i think about it, the more I'm sure this will either need a macro (which I'm altogether new to) or manual copy/paste action which defeats the purpose.
Appreciate any help.
Dave.
Bookmarks