Auto-Filling Data from extensive lists

Hello all,

I've recently been given the task of inputting data from a large list into a sort-of master sheet. Currently, the only solution anyone has is to manually enter each number, but I find it hard to believe that there's no way to make Excel do this for us. Unfortunately, I'm no expert. Any help would be greatly appreciated.

A vague example of our master sheet would be as follows:

1
2
4
5
6
7
8
9
11
12
13
14
15
16
18
19
20

We are given data that corresponds to the master as such:

1 1345
2 563
4 435
5 6
8 456
11 456
15 2
16 45
18 5234625
19 2436
20 456

What I want the final product to be:

1 1345
2 563
4 435
5 6
6
7
8 456
9
11 456
12
13
14
15 2
16 45
18 5234625
19 2436
20 456

We can't simply remove row "7" for example, even though there's no data currently, because on a different day there may be data in that row. As well, the master is far from a full list of numbers. They're actually all codes that are numerically sorted, but far from sequential, which is why a few row numbers were skipped in the example.
Also, the actual lists we're working with are about 50x larger, or more. I've experimented with logical if/then formulas, but was only able to populate one cell. When I tried to fill the formula down to subsequent cells, all it gave me was "FALSE."

I apologize if this is a little on the basic side, but I've tried searching the webs to no avail. Thanks in advance for any help I can get!

You could use VLOOKUP to extract the information from the Data Tables provided they all have a common key field to the left of the data. Or you could use INDEX/MATCH.

Regards, TMS

=iferror(VLOOKUP(A1,[Workbook3]Sheet1!$A$1:$B$11,2,FALSE),"")

You're welcome. Thanks for the rep.