+ Reply to Thread
Results 1 to 3 of 3

return first four characters AFTER index match formula

  1. 07-23-2015, 07:07 PM #1
    ammartino44
    ammartino44 is offline
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    return first four characters AFTER index match formula

    Hello. After I use this formula how can I use the left formula? =INDEX(Sheet1!C:C,MATCH(Sheet2!A3,Sheet1!D:D))
    Reply With QuoteRegister To Reply
  2. 07-23-2015, 07:12 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: return first four characters AFTER index match formula

    to do what? perhaps a sample would help?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 07-23-2015, 07:17 PM #3
    quekbc
    quekbc is offline
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: return first four characters AFTER index match formula

    Is this what you meant?

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    If not, what Ford said.
    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. Help with index and / or match formula with multiple match required to return a value
    By ACLARKE in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-16-2016, 02:33 AM
  2. Index/Match Formula to return multiple results
    By MikeSta4ord in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-11-2015, 11:32 AM
  3. Need help with formula to look up last date in row and return col # for index/match formul
    By shellecj in forum Excel General
    Replies: 0
    Last Post: 04-12-2015, 07:36 PM
  4. Please help: Non-VBA INDEX MATCH formula to return values to the right of first value?
    By smcmahon83 in forum Excel General
    Replies: 2
    Last Post: 02-20-2015, 05:23 PM
  5. [SOLVED] Formula index match return 1st value then 2nd, 3rd etc.
    By Leoparddd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2014, 08:15 PM
  6. SUMIF, Index and Match Formula. Return Cell value
    By FLani in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2014, 02:43 AM
  7. Index/match formula - return #n/a error
    By jBailey031285 in forum Excel General
    Replies: 2
    Last Post: 03-13-2012, 05:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1