Column A Column B Column C Column F Column G Column H
DATE PRODUCT QTY DATE PRODUCT QTY
Oct 05 Apples 2
Oct 03 Orange 1
Oct 10 Candy 1
Oct 03 Cookies 5
Oct 03 Grapes 3
Oct 07 Apples 6
Oct 03 Orange 1

QUESTION? Extract all "OCT 03" dates put on "Column F",
"PRODUCT" put on "Column G",
"QTY" put on "Column H" by using formula only.

"VLOOKUP"??? the problem with "VLOOKUP" only looks for first row with the Oct 03 date. I need the formula to get the next Oct 03 row going down the Column A and transfer data continuously down Column F. This formula needs to continue pulling every occurance of the Oct 03 date. Any help with solving this problem is appreciated.

Dan