I have a complete email list beginning in column C with the associated names and info in columns D-G. In column A is a shortened list of Emails from C that i would like to keep but they are not associated with the data. How can I match this column with the emails and data in CDEFG?
rumbleon,
In column B1, paste the following formula replacing “9” and “99” with the numbers of the first and last line of the shortened list. Then copy it downward until the last line of the complete list.
=VLOOKUP(C1,$A$9:$A$99,1,FALSE())