lookup help

R

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!
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching rows 2
Help matching entries in two sheets??? 2
Help w/Match or Lookup 2
Looking up with more than 1 criteria 5
Formula within a formula 1
select data from a table 10
Could someone please help me w/ matching the contents of each two sheets? 3
help needed with lookup and related functions 3

Top