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.