+ Reply to Thread
Results 1 to 2 of 2

Adding text to an INDEX/MATCH Arrays answer

  1. #1
    Registered User
    Join Date
    08-23-2019
    Location
    South Africa
    MS-Off Ver
    2016
    Posts
    5

    Adding text to an INDEX/MATCH Arrays answer

    Hi Experts

    I would like to add a bit of text, "SAMPLETEXT" to a INDEX/MATCH Arrays answer.

    So my INDEX/MATCH arrays answer brings me back an answer like the following when i F9 it:
    ={"TEST NOTES 1";"TEST NOTES 2";"TEST NOTES 3";"TEST NOTES 4";"TEST NOTES AA";"TEST NOTES BB";"TEST NOTES CC"}

    I would like to add "SAMPLETEXT" to this answer using a formula.

    If i use CONCATENATE formula, I get the following answer:
    ={"SAMPLETEXT";"SAMPLETEXTTEST NOTES 1";"SAMPLETEXTTEST NOTES 2";"SAMPLETEXTTEST NOTES 3";"SAMPLETEXTTEST NOTES 4";"SAMPLETEXTTEST NOTES AA";"SAMPLETEXTTEST NOTES BB";"SAMPLETEXTTEST NOTES CC"}

    But i am looking to get:
    ={"SAMPLETEXT";"TEST NOTES 1";"TEST NOTES 2";"TEST NOTES 3";"TEST NOTES 4";"TEST NOTES AA";"TEST NOTES BB";"TEST NOTES CC"}

    Thanks
    AE10

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Adding text to an INDEX/MATCH Arrays answer

    Not showing your actually formula and data is going to make it hard to suggest a solution that actual works.

    But you need to include an extra area to the test data and include a conditional test that will either return SAMPLETEXT or "". it also needs to return "" for you original set of returned values.

    The attached is a very contrived example but hopefully you can apply it to your actual data.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  2. Trying to use match and index but return a text not numercial answer
    By parrot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-04-2013, 10:44 AM
  3. [SOLVED] Index & Match returning incorrect value. Arrays fixed and exact match used.
    By SDes in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-07-2012, 08:29 PM
  4. Help PLEASE! Not sure what answer is: Match? Index? Other?
    By baz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  5. Help PLEASE! Not sure what answer is: Match? Index? Other?
    By baz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  6. Help PLEASE! Not sure what answer is: Match? Index? Other?
    By baz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. [SOLVED] Help PLEASE! Not sure what answer is: Match? Index? Other?
    By Conrad Carlberg in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 09-06-2005, 09:05 AM

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