Thread: Need to match colum 1 in two different sheets, and insert colum 2 and 3

I have two sheets with this data:

For sheet 1, a piece of the data is like this:

Entry Hybrid Company

1 Belle 1533Y Belle Southern Hybrids
2 Belle 1525R Belle Southern Hybrids
3 Belle 1545RY Belle Southern Hybrids
4 Belle 1747 RY Belle Southern Hybrids

for the sheet 2, I have just have the entry number replicated four times:

Entry number
1
1
1
1
2
2
2
2
3
3
3
3
4
4
4
4

I need to match entry number in sheet 1 and 2, then insert column 2 and 3 in sheet two.

The way that the data have to be arranged is this:

1 Belle 1533Y Belle Southern Hybrids
1 Belle 1533Y Belle Southern Hybrids
1 Belle 1533Y Belle Southern Hybrids
1 Belle 1533Y Belle Southern Hybrids
2 Belle 1525R Belle Southern Hybrids
2 Belle 1525R Belle Southern Hybrids
2 Belle 1525R Belle Southern Hybrids
2 Belle 1525R Belle Southern Hybrids
3 Belle 1545RY Belle Southern Hybrids
3 Belle 1545RY Belle Southern Hybrids
3 Belle 1545RY Belle Southern Hybrids
3 Belle 1545RY Belle Southern Hybrids
4 Belle 1747 RY Belle Southern Hybrids
4 Belle 1747 RY Belle Southern Hybrids
4 Belle 1747 RY Belle Southern Hybrids
4 Belle 1747 RY Belle Southern Hybrids

and so on....

I know that I can do this by copy and paste, but I have a large amount of data so I need to do it in a better way, please, I need some help. When I work in a previous company, they used a macro to match data columns, then insert the next 2,3 or 4 colums. I know that there is a way to do it, but I do not know how

Does somebody know?
thanks for your help

Not sure why you would want to do that, but:

Sheet 2, B2:=VLOOLUP(A2,'Sheet 1'!A:D,2,FALSE)
Sheet 2, C2:=VLOOLUP(A2,'Sheet 1'!A:D,3,FALSE)
Sheet 2, D2:=VLOOLUP(A2,'Sheet 1'!A:D,4,FALSE)

and copy down.

Regards

You're welcome.

If that answers your question, please mark the thread as SOLVED

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

Regards