VLOOKUP or INDEX,MATCH - how to deal with situation when source will change?
I have a MASTER contact list, which has every contact that we ever have. Primary key is email address.
Then i have a template where a person picks a user from a Contact List and a bunch of columns get populated with phone, city, etc when the email address for the user is matched against the Master.
So that template has been used for about 50 contact list Sheets.
And now I want to add some columns to the Master.
And this means that all of the column indexes are going to change. So I need to edit every one of those contact lists.
Is there a way around this?
*Wouldn't it be cool if there was a mechanism where we could edit a template, and those changes would push out to all of the sheets that were built from that template?