+ Reply to Thread
Results 1 to 4 of 4

Embed left function in match/index function

  1. #1
    Registered User
    Join Date
    05-12-2016
    Location
    Germany
    MS-Off Ver
    2010
    Posts
    6

    Embed left function in match/index function

    Hi all,

    I have the following function: =INDEX($H$1:$H$960; MATCH(LEFT(A2;3);$B$1:$B$960;0))

    What I need to do is match the first 3 letters of A2 to the first three letters in the range B1:B960, then whatever row is matched in the B range must be taken by the index function, matched with the H column and have the word from the H column Output into the appropriate cell.

    At first I was referencing all of cell A2 (no left function) and had no Problems but it turns out I need to only reference the first 3 numbers in A2 and match them to the first 3 numbers in the range B1:B960. Hope someone can help!

    Thanks in advance!

    -Kyle
    Last edited by Kyle18; 05-12-2016 at 05:10 AM.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Embed left function in match/index function

    Perhaps

    =INDEX($H$1:$H$96;MATCH(LEFT(A2;3),INDEX(LEFT($B$1:$B$9600;3);0))
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    05-12-2016
    Location
    Germany
    MS-Off Ver
    2010
    Posts
    6

    Re: Embed left function in match/index function

    Thanks for the quick response Ankur! You nailed it.

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Embed left function in match/index function

    Thanks for rep and feedback there

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  2. Wrapping an if function around an Index/Match function - need help ;)
    By tonyridino in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2015, 08:38 PM
  3. Need help nesting an index/match function within a Vlookup function.
    By Christopher135 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2013, 06:16 PM
  4. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  5. nested MATCH function within the INDEX function
    By thechoosenonesdream in forum Excel General
    Replies: 4
    Last Post: 10-25-2012, 03:55 PM
  6. Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  7. [SOLVED] Emulate Index/Match combo function w/ VBA custom function
    By Spencer Hutton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2005, 01:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1