Results 1 to 3 of 3

Thread: Formula for index match if two different lengths

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

    Formula for index match if two different lengths



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

    I'm using index match to match an id from one worksheet1 to worksheet 2 and populate the field worksheet 1 (ROW H). However, the index match isn't working for the entire array--I'm guessing it's because of the different lengths?? Is there something else I can do?
    Attached Files Attached Files

  2. #2
    Seeker Roger Haney's Avatar
    Join Date
    Jan 2021
    Posts
    7
    Articles
    0
    Excel Version
    Microsoft Excel Office 365
    Show the actual Index/Match formula that you are using to populate Column H in worksheet 1.
    Last edited by Roger Haney; 2021-01-24 at 06:01 PM. Reason: Spelling error

  3. #3
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,846
    Articles
    0
    Excel Version
    O365
    This works for me

    =INDEX(Worksheet2!H:H,MATCH(worksheet1!D2,Worksheet2!D:D,0))

Tags for this Thread

Posting Permissions

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