How do I vlookup multiple rows with same reference?

  • Thread starter Thread starter Kathie C
  • Start date Start date
K

Kathie C

I have 2 worksheets - 1 sheet to pull into and the second sheet is a list of
source data.
First sheet
Number Date Qty Date Qty
12345 12/1/08 3 1/6/09 4

Second sheet
12345 12/1/08 3
12345 1/6/09 4
12345 2/7/09 5

I want to pull in the first date reference on sheet 2 into date 1 on sheet
1, qty 1 from sheet 2 into sheet 1 Qty 1, Date 2 from sheet 2 into Date 2 on
sheet 1, qty 2 from sheet 2 into qty 2 on sheet 1 and so forth. VLookup will
only pick up the first instance for that reference number (12345) from the
list on sheet 2. Can anyone help me with a formula to pick up the 2nd, 3rd
(and so forth) references from the list for the same number? Any help would
be greatly appreciated.
Thank you
 
Use AutoFilter.

You can selectively display all rows that have 12345 in the given column.
Then just copy/paste the visible rows.
 

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

Vlookup 3
To Calculate the qty b/w two dates 6
next row formula 7
Match and delete rows on two different sheets from reference numbers 4
Excel Workbook with Multiple worksheets 2
Conditionnal Formatting 3
Matching criteria and summing 1
Basing math on duplicate entries in a formula 1

Back
Top