I have a contacts list with an INDEX MATCH search function (Contacts Worksheet). The problem I discovered exist with contacts with the same name. i.e if I search “Alan” only the first the occurrence is displayed and am unable to seek the next in the list. The goal is to use the search function to pull each record instance. The more I look into INDEX MATCH, the less I think I can use it to pull each instance. I tried a variation with Vlookup but ran into similar issues.
Any assistance would be greatly appreciated.
Bookmarks