Fetching more than one result with VLookup on multiple sheets

[lilvillaf]

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

[BobBridges]

If your native language is English, lilvillaf, you really should try harder to communicate. (If it isn't, I forgive you .) Here are some questions:

1) "I am trying to pull more than one result from vlookup...." Sorry, but VLOOKUP returns just one value at a time.

2) "... from vlookup and match doesn't seem to work...." MATCH doesn't work? I thought it was VLOOKUP you were trying to use.

3) "...match doesn't seem to work...." In what way, exactly? I mean, what are the symptoms?

4) "...match doesn't seem to work as I have over a thousand values...." That shouldn't make any difference. Oh, if MATCH (or VLOOKUP) has to search through enough values it might slow down, but it'll still work.

5) "...over a thousand values (the reference from which vlookup will start)...." I can't make out what the parenthesis means.

6) "...I also tried indexing..." Someone else here may know what indexing is, in Excel, but I'm not sure. Do you mean you tried the INDEX function? How?

7) "...I also tried indexing and it didn't work either." As with MATCH, the question is how it didn't work. What symptoms? What did it do instead? What did your function call look like?

8) "Main tab: just a few rows (there are over 1K)....Secondary tab: (source) - just a few rows (there are over 10K)...." What do you mean by saying there are "just a few" rows and also thousands?

There are more, but that'll do to start with.

[macropod]

See:
http://windowssecrets.com/forums/sho...l=1#post734296
http://www.techsupportforum.com/foru...ml#post2567119