lookup help

  • Thread starter Thread starter Relak
  • Start date Start date
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!
 
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
Dictionary and std::multimap 13
Query a table using a field 1
IF FUNCTION? 6
Help Please 2
Help using Transpose 6
Referencing a filename in a formula 2
combine worksheets and populate fields 1

Back
Top