Results 1 to 4 of 4

Thread: Vlookup - Multiple Columns matching

  1. #1
    Neophyte grb231's Avatar
    Join Date
    May 2020
    Posts
    2
    Articles
    0
    Excel Version
    office 365

    Vlookup - Multiple Columns matching



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Everyone:

    I'm pretty new to excel and have an issue trying to identify data across 4 columns. I have to sets of data set up as

    ID Number Name ID Number Name

    Columns A&B have 17,500 rows and columns C&D have 6,200 rows.

    I'm trying to run vlookup to identify ID numbers in Column A that match ID numbers in Column C, with result appearing in Column E.

    If anyone can help I'd really appreciate it. I've been working on this for hours and to be honest am totally lost at this point.

    Thank You

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,782
    Articles
    0
    Excel Version
    O365
    Where is the multiple columns match? what is the result for column E?

  3. #3
    Neophyte grb231's Avatar
    Join Date
    May 2020
    Posts
    2
    Articles
    0
    Excel Version
    office 365
    Quote Originally Posted by Bob Phillips View Post
    Where is the multiple columns match? what is the result for column E?
    Sorry maybe I got it wrong - I'm trying to match the ID number from Column A with the ID number in Column C and have the result (Column A value) appear in Column E

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,782
    Articles
    0
    Excel Version
    O365
    Try this

    =IF(ISNUMBER(MATCH(A2,$C:$C,0)),A2,"")

Posting Permissions

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