I have two colums of data.
Structured as following:

Jonh Doe Car1
Jonh Doe Car12
Jonh Doe Car44
Jonh Doe Car2
Jane Doe Car3
Jane Doe Car4
Jane Doe Car5
Jane Doe Car6

Im looking for a formula similar to vlookup to pick up a value from second
column, but one that will go to the next row and not just bring back the
first match as i copy the formula down.

Any ideas?

Thanks for the help!