Forum Discussion

Kim-MS-Acct Groneman's avatar
Kim-MS-Acct Groneman
Copper Contributor
Aug 17, 2018
Solved

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's avatar
    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.

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Aug 18, 2018

Mr. Amairah

Nice solution..

I have learned recently how to avoid #N/A by using IFERROR formula

= IFERROR(VLOOKUP(F4,$A$4:$B$12,2,0),"")  or

= IFERROR(VLOOKUP(F4,$A$4:$B$12,2,0),"Not found!")

I hope I am correct...

thank you..

 

 

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Aug 18, 2018

Hi Lorenzo Kim,

 

Yes, that's correct.

But if you have Excel 2013 or later, I recommend you to use https://support.office.com/en-us/article/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461 function instead.

IFERROR will hide all types of errors while IFNA is only for the #N/A error type.

The benefit is that you will be alerted if an error other than #N/A occurred.

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Aug 18, 2018
    thank you for the info..

Resources