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:
Sub Macro3()
'
' Macro3 Macro
' Macro recorded 13/05/2005 by neilsona
'

'
  Do
        ActiveCell.FormulaR1C1 = "=VLOOKUP(R9C2,CVs!R[-11]C[-1]:R[212]C,1,)"
  Loop While B11 = B10
End Sub
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.