All you need is the VLookup cell function. Say column A has first name, col B has last name, and C username. You need to set Username as column A. To do this, just cut the entire column and insert it as column A (copy/paste).
Now, to get the First Name, use this (assuming First name is now col B):
=vlookup(A2,MasterList!$A$2:$C$11000,2,false)
And for last name, use this:
=vlookup(A2,MasterList!$A$2:$C$11000,3,false)
Note that the 11000 is the last row containing info on MasterList, and A2 is supposed to be the start of it, and, in mail1 through 5, I assume the username you want to search for is contained in column A.
Enter your message below
Sign in or Join us (it's free).