Find A Small Array In A Larger One And Copy Relative Cells Of The Row

Hello Everyone,

My version of MS Office is 2007. I think there is no simple solution for my question - If there is a solution without using Macros then perfecto!!! But anyway if Macros can give a definitive answer, please don't hesitate to share it as I desperately need to know this. However, I never used macros, but anyway...........

I have a random numbers array say from A2 to A12 filled with random numbers on Sheet1.
Random numbers.jpg
At the same time I have a large table which contains a lot of data, including my random numbers on Sheet2.
Table array.jpg

Now my question is - On Sheet 3 I want to extract respective rows from the Table array. I need to find all the values of the small array in the large table's column A, and extract respective rows in Sheet3.
Final result.jpg

In other words - I want to find A2 value in the Column A of the Table array and copy the remaining row into another sheet. Then look for A3 in the table, then A4, etc.. But I want the Excel to do it for me, otherwise this whole thing is pointless.

One thing that is for sure - the random values are unique. so there shouldn't be any duplicates. Each random value in both arrays appears only once.

If you read up to this point, then first of all thanks for your time, secondly if you think this is way too easy, then sorry.

Anyway, I appreciate any help.

Try in Sheet3!B2

Formula:

Please Login or Register  to view this content.

and copy down and forward

I suppose I need to change Folha into Sheet in the provided formula. Unfortunately it didn't work for me

I've sorted out kinda... I've changed second folha into Sheet 1 in the MATCH function as it should read from the first sheet.
it worked for me, but the problem is that the function does not return the Random number in Sheet 3. It returns whatever is in front of Random number. I'd like to have random number as well as shown in picture (Sheet3).

Thanks a lot for your reply. it helped a lot!!