+ 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
    2003, 2007, 2010 & 2013
    Posts
    18,610

    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)

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