Hi, I'm currently trying to design a database with a search function that returns a list of information (Up to 5) and not just the first one it finds, but not having much luck so far, I have attempted with VLOOKUP formulas and not got very far, so I have decided to try using macros.

What I have tried to do is this:
Please Login or Register  to view this content.
Where the VLOOKUP formula is othe 2nd of the 5 search formulas and B11 and B10 are the results (B10 being the result for the first VLOOKUP formula and B11 for this one)
I want to be able to add 1 to R[-11], until B11 eventually comes up with a different result from B10.