• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do you import an email column to another worksheet and match up to a user id

G

GRODZ

New Member
user name first name Last Name email address

DoeJ John Doe xxx@xxx.xxx


Need to import and match up the email address from a different worksheet to match up with the user id and first and last name.
 
Hi,

There are couple of options like comparing individual columns to columns comparison and and than looking whether they match or not OR doing a combined concatenation matching and get the result.

Are these different worksheets in same workbook or different workbooks?

Can you upload a sample file.

Regards,
 
Attached is a test file, the workbook has two separate work sheets.
So I need to match up the email from work sheet 2 to work sheet 1 or line it up to the user id in worksheet 1.
 

Attachments

I suppose the user id are unique and there will not be duplicates in it, if so than try below formula on sheet1 G2 and copy down.

=VLOOKUP(Sheet1!A2,Sheet2!$A$2:$H$5,7,0)

Regards,
 
The formula works on the test work sheet but when I try to apply it to the real spreadsheet it returns an N/A.
 
You must log in or register to reply here.
Back
Top