Hi all,
I have an excel book with 2 sheets, I want to search on sheet 1 for a criteria and return the results from sheet 2. But in some cases there are multiple matches so I need 2 buttons, previous and next which let me return the record. Like "viewing 1 of 3", 2 of 3, 3 of 3.

How can I do this, I was using index match but it only returns the first value.

Index_Search.xlsb