I have spent the last few days looking through posts from people who are having similar issues as I am having now. I have tried several example formulas, but I keep ending up with the same problem; I am expecting to see four results but am only getting the first match to show up and then it stops. In the example workbook that I have attached I am expecting to get the following results back; 990541, 990541-MODIFY, 990541-MODIFY 2 and 990541-MODIFY 3. Thank you for looking.
Formula:
Please Login or Register to view this content.
Confirmed as Array (CTRL + SHIFT + ENTER). Copy down.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
INDEX/MATCH (and vlookup) will always only ever return the 1st match - then stop looking.
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
Thank you very much. I did have to change the 'search column' to [Column4] instead of [Text], but this works exactly as I was looking for it to. I also added "IFERROR" to the start of the formula and ended it with ,"") in order to hide the errors that show up when there are no more matches. I re-attached the workbook also for anyone else who would like to reference it.
Last edited by jakeh2475; 05-24-2018 at 02:07 PM.
You are welcome and thanks for the rep
For some reason I wasn't able to attach the revised version of the workbook, so here goes again...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks