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