Ask Your Question
0

sorting email list

asked 2020-05-22 03:53:49 +0200

rumbleon gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-05-22 17:42:05 +0200

LeroyG gravatar image

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())
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-05-22 03:53:49 +0200

Seen: 17 times

Last updated: May 22