+ Reply to Thread
Results 1 to 7 of 7

Lookup unique value in multiple columns

  1. 11-25-2021, 10:15 AM #1
    q8books
    q8books is offline
    Registered User
    Join Date
    09-28-2009
    Location
    kuwait
    MS-Off Ver
    MS365 MSO 16.2.13127.21624
    Posts
    29

    Lookup unique value in multiple columns

    Greetings.

    I am struggling with looking up a value across three columns (three different unique employee ID numbers) and returning the name. The basic vlookup function that I employ is not reading multiple columns.

    Any help would be most welcome.

    Thank you.

    Jacob
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 11-25-2021, 10:20 AM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Lookup unique value in multiple columns

    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    =INDEX($F$1:$F$200,AGGREGATE(15,6,(ROW($F$1:$F$200)-ROW($F$1)+1)/($A$1:$E$200=H2),1)) you may need to change the ranges.
    Reply With QuoteRegister To Reply
  3. 11-25-2021, 12:14 PM #3
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Lookup unique value in multiple columns

    Edit: Are you still using Excel 2003 as your profile shows? If not please update your profile to show which version. It's important ... for example Fluff's AGGREGATE function was introduced in Excel 2010.

    Another way.

    In F2 this and filled down.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    A
    B
    C
    D
    E
    F
    1
    ID 1
    ID 2
    ID 3
    Names
    2
    5077
    8130
    Bob
    5077
    Bob
    3
    9492
    John
    5893
    Rachel
    4
    7432
    3120
    Mike
    4396
    Elsie
    5
    5702
    Jacob
    6
    3858
    6630
    9075
    Kelly
    7
    2401
    4196
    2275
    Martha
    8
    2327
    5935
    Joe
    9
    6496
    2570
    5893
    Rachel
    10
    3258
    Liz
    11
    2738
    4396
    Elsie
    12
    7777
    9754
    JoAnne
    13
    5522
    9983
    Allen
    Last edited by FlameRetired; 11-25-2021 at 12:18 PM.
    Dave
    Reply With QuoteRegister To Reply
  4. 11-25-2021, 03:06 PM #4
    q8books
    q8books is offline
    Registered User
    Join Date
    09-28-2009
    Location
    kuwait
    MS-Off Ver
    MS365 MSO 16.2.13127.21624
    Posts
    29

    Re: Lookup unique value in multiple columns

    Thanks Dave. Works perfectly. Appreciate it.
    Reply With QuoteRegister To Reply
  5. 11-25-2021, 03:08 PM #5
    q8books
    q8books is offline
    Registered User
    Join Date
    09-28-2009
    Location
    kuwait
    MS-Off Ver
    MS365 MSO 16.2.13127.21624
    Posts
    29

    Re: Lookup unique value in multiple columns

    Thanks Fluff13. Appreciate your time and assistance. T
    Reply With QuoteRegister To Reply
  6. 11-25-2021, 03:14 PM #6
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Lookup unique value in multiple columns

    Fluff's AGGREGATE function was introduced in Excel 2010.
    Oops, forgot to check what version was being used.
    Reply With QuoteRegister To Reply
  7. 11-26-2021, 05:01 PM #7
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Lookup unique value in multiple columns

    @ q8books

    You are welcome. Thank you for the feedback and marking your thread Solved.
    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)

Similar Threads

  1. [SOLVED] Transpose data in six columns into unique and multiple rows based on unique club name
    By JimmyB11 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-04-2021, 09:12 AM
  2. Create unique list from multiple columns using UNIQUE
    By PingTing in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-30-2020, 10:40 PM
  3. Extract unique values from multiple columns using "UNIQUE" dynamic array function
    By Adamro in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-16-2019, 10:59 AM
  4. [SOLVED] Lookup multiple columns and return cell in different column when they become unique
    By CB5 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-21-2017, 03:43 PM
  5. [SOLVED] A lookup function based on two criteria; one unique & one not unique to the lookup table
    By Trevasaurus in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2014, 11:35 AM
  6. [SOLVED] Multiple Lookup Values rows and columns to lookup a single target column on the right end.
    By gurusanthanam in forum Excel General
    Replies: 3
    Last Post: 04-08-2014, 03:11 AM
  7. lookup unique value in column A then display todays date eight columns across ??
    By michaelproctor001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2013, 11:14 AM

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