lookup help

[Relak]

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!

 

[goshute]

I am a bit confused by the same name beign associated with several
Cars. But, how about adding a new column that has the value of the
next row. Example, cell C1 would have the formula =B2, etc. Then use
a standard VLOOKUP formula and instead of returning column 2, return
column 3, the new column.

Goshute