Return multiple values based on one matching field

Thanks for the response. Right now the lists are separate spreadsheets - data that I've exported from our old and new database systems. I've attached a sample workbook with separate sheets for OLDID and NEWID data. I'd like to end up with a list of First Name, Last Name, Email Address, OLDID, NEWID - if possible.