Match cells on two sheets, copy columns to sheet 3

Hello everyone,

I attached an example. In this example I have 3 sheets.
The first 2 sheets contain "data". The last sheet contains an example of what I would like to have in the end.

What I would like to do is compare the first 2 sheets with the "Numbers" column. This column doesn't necessarily has to be in the same column.
If the numbers from sheet 2 are found on sheet 1, I want to copy specific data to the third sheet, which is normally empty.
In this case column B from sheet 1 and column J from sheet 2.

Thanks in advance.

Kind regards,

Marco

An alternative way with formula.

In B2 use

Please Login or Register  to view this content.

In C2 use

Please Login or Register  to view this content.

Formulas can be dragged down.

@Leith
Thanks a lot for this solution! It works great!
I only have one thing though. Perhaps I wasn't too clear, but it doesn't matter whether or not one of the data fields is empty, like you put in your example.
It still needs to be copied. If there is a matching invoice number, the data, whether or not present, should be copied to Blad3.

So on Blad3, one row could look like this, with Data2 missing. The only thing needed is a matching "Number". On the original file cells should not be empty, if so, there is something wrong :P
But just in case, it should copy anyway.

Please Login or Register  to view this content.

@kvsrinivasamurthy
I'm not really sure what your formula has to do since I cannot get them to work. I translated them to Dutch but I still get an error.
If I read the formula correctly I think they are matching the numbers in column A from Blad3 with the numbers on Blad1 and Blad2, depending one which formula you read.

Normally Blad3 would be empty and the numbers on Blad1 and Blad2 should be compared. If there are matches, the found numbers plus the data on the same rows should be copied to Blad3.
Blad3 in the file in my first post is how it should look like in the end.

If that's exactly what your formula should do, forget what I said.

Kind regards,

Marco