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