Hi.

I am trying to pull more than one result from vlookup and match doesn't seem to work as I have over a thousand values (the reference from which vlookup will start) and I also tried indexing and it didn't work either.

Main tab should pull info from secondary tab from 'Item' value and show all open orders in different columns (one order number on each)...

Main tab: just a few rows (there are over 1K)

Item #Open OrdersDate 1Date 2Date 3DateQtyDateQtyDateQty003176M 003303AM-100 003304AM-100 003306AM-100 003307AM-100 003308AM-100 003322P 10034-420-4C 10034-424-4C 10359-060

Secondary tab: (source) - just a few rows (there are over 10K)

Item Order 1258P113269 1258P113657 1258P110467 1258P113167 1260P112698 3004P110606 3004P111393 3004P112485 3006P113733 3006P112914