I have an xls file called "Masterlist" that has hundreds of contacts, i.e. Member ID, first name, last name, phone, and email in respective columns/rows.
I have another xls template that only contains Member ID in a column. I need a formula/method to auto fill/populate the remaining info, i.e. first name, last name, phone, and email per row that matches Member ID on the template file from the Masterlist xls file.
I'm assuming it's a vlookup or lookup formula, but need a bit more direction and most efficient method.