Matching an entry from 2 sets of data

Hi, and thanks in advance for any help. I have one set of data (let's call this data set 1) that is email addresses (column1) and a user ID (column2) . I have another set of data (data set 2) pu...

excel

Formulas and Functions

Haytham Amairah
Aug 18, 2018
Hi,

You can use VLOOKUP as the example below.
Cell G4: =VLOOKUP(F4,$A$4:$B$12,2,0)

Please check out this https://support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1 to learn more about VLOOKUP function.
I hope that helps.

Haytham Amairah

Silver Contributor

Aug 18, 2018

Hi,

You can use VLOOKUP as the example below.

Cell G4: =VLOOKUP(F4,$A$4:$B$12,2,0)

Please check out this https://support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1 to learn more about VLOOKUP function.

I hope that helps.

Kim-MS-Acct Groneman

Copper Contributor

Aug 20, 2018

Thanks Haytham. That works perfectly!

Forum Discussion

Matching an entry from 2 sets of data

Resources