+ Reply to Thread
Results 1 to 8 of 8

Comparing 2 lists using VLOOKUP

  1. 03-24-2013, 06:48 AM #1
    ksnr2006
    ksnr2006 is offline
    Registered User
    Join Date
    03-24-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2003
    Posts
    7

    Comparing 2 lists using VLOOKUP

    I have four coloumns :


    DB1 UIDs DB1 Email ID DB2 UIDs DB2 Email ID
    aaaa [email protected] eeeeee [email protected]
    bbb [email protected] ccccc [email protected]
    ccccc [email protected] aaaa [email protected]
    ddddd [email protected] bbb [email protected]
    eeeeee [email protected] ddddd [email protected]
    ggggg [email protected]
    hhhh [email protected]


    I need to Compare DB1UID with DB2 UIDs. If the UID exists in DB2 UIDs list, need to print that UID and its respective email id from DB2 email id in seperate coloumns(E and F) so that I can check whether the DB1 user exists in DB2, if Yes, with the same email id or different one.

    Ex: user CCCCC has different email id in DB1 and DB2

    I am poor in English.. sorry for my bad english.

    Thank you in advance.
    Satya.
    Last edited by ksnr2006; 03-24-2013 at 06:50 AM.
    Reply With QuoteRegister To Reply
  2. 03-24-2013, 06:56 AM #2
    Aladin Akyurek
    Aladin Akyurek is offline
    Forum Contributor
    Join Date
    12-23-2003
    Posts
    179

    Re: Comparing 2 lists using VLOOKUP

    E2, copy down:

    =IFERROR(VLOOKUP(A2,C:D,1,0),"Not Available")

    F2, copy down:

    =IFERROR(VLOOKUP(A2,C:D,2,0),"Not Available")
    Reply With QuoteRegister To Reply
  3. 03-24-2013, 07:12 AM #3
    ksnr2006
    ksnr2006 is offline
    Registered User
    Join Date
    03-24-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Comparing 2 lists using VLOOKUP

    Quote Originally Posted by Aladin Akyurek View Post
    E2, copy down:

    =IFERROR(VLOOKUP(A2,C:D,1,0),"Not Available")

    F2, copy down:

    =IFERROR(VLOOKUP(A2,C:D,2,0),"Not Available")
    ========================

    I have tried this but getting =REF? like error... I have attached the file where you can see the example data. I need to compare 2 databases user names and respective email ids.
    example.xls
    Reply With QuoteRegister To Reply
  4. 03-24-2013, 07:50 AM #4
    Aladin Akyurek
    Aladin Akyurek is offline
    Forum Contributor
    Join Date
    12-23-2003
    Posts
    179

    Re: Comparing 2 lists using VLOOKUP

    Are you on a 2003 system or later?
    Reply With QuoteRegister To Reply
  5. 03-24-2013, 07:59 AM #5
    ksnr2006
    ksnr2006 is offline
    Registered User
    Join Date
    03-24-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Comparing 2 lists using VLOOKUP

    I have both Excel 2003/10 versions.
    Reply With QuoteRegister To Reply
  6. 03-24-2013, 08:14 AM #6
    Aladin Akyurek
    Aladin Akyurek is offline
    Forum Contributor
    Join Date
    12-23-2003
    Posts
    179

    Re: Comparing 2 lists using VLOOKUP

    Quote Originally Posted by ksnr2006 View Post
    I have both Excel 2003/10 versions.
    On 2010...

    E2, copied down:

    =IFERROR(VLOOKUP(A2,C:C,1,0),"Not Found")

    F2, copied down:

    =IF(E2="Not Found","NA",IF(B2=VLOOKUP(A2,C:D,2,0),B2,"Not Matching"))

    Both on 2003 and 2010...

    E2, copied down:

    =IF(ISNA(VLOOKUP(A2,C:C,1,0)),"Not Found",A2)

    F2, copied down:

    =IF(E2="Not Found","NA",IF(B2=VLOOKUP(A2,C:D,2,0),B2,"Not Matching"))
    Reply With QuoteRegister To Reply
  7. 03-24-2013, 08:21 AM #7
    ksnr2006
    ksnr2006 is offline
    Registered User
    Join Date
    03-24-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Comparing 2 lists using VLOOKUP

    Thank u.Thank u.Thank u.Thank u.Thank u.Thank u.Thank u.Thank u.Thank u.Thank u.Thank u.Thank u.Thank u.


    Thank you soooooo much.............Aladin Akyurek

    Satya..
    Reply With QuoteRegister To Reply
  8. 03-24-2013, 08:33 AM #8
    Aladin Akyurek
    Aladin Akyurek is offline
    Forum Contributor
    Join Date
    12-23-2003
    Posts
    179

    Re: Comparing 2 lists using VLOOKUP

    Satya, you are welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1