Results 1 to 2 of 2

Thread: Match first & last name return value

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker excelnewbie12345's Avatar
    Join Date
    Jun 2019
    Posts
    8
    Articles
    0
    Excel Version
    16.24

    Match first & last name return value

    I am trying to match a last and first name (just a few letters of the first name) and the return value is the ID number. I can't get this to work... is index match the best way or vlookup???

    Here is my example. The formula is within the spreadsheet.


    Thank you!
    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,713
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    This maybe:

    =LOOKUP(2,1/((A2=Sheet1!A:A)*(B2=Sheet1!B:B)),Sheet1!C:C)
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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