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
Bookmarks