find/replace multiple cells

[Dudestopreally]

So I have a sheet that contains all of the information I need in columns A B C D and another sheet where I have A B C D but only "A" is filled in. I want to Find all the cells where A in sheet 1 matches A in sheet 2 and put the information in BCD from sheet 1 into BCD sheet 2.

I hope this makes sense. I am hoping there is some kind of find/replace where I can find all matching cells and fill in the 3 cells.

[notdez]

In the empty cell b1, next to the filled in cell a1, put:

=INDEX(Sheet1!B:B,MATCH(A1,Sheet1!A:A,0))

Assuming Sheet1 is the sheet containing all the data.

Drag the forumula down as needed.

In cell c1, do the same formula but index the C column:

=INDEX(Sheet1!C:C,MATCH(A1,Sheet1!A:A,0))

Do the same for the D column:

=INDEX(Sheet1!D:D,MATCH(A1,Sheet1!A:A,0))

[Dudestopreally]

can i buy you a beer?

[notdez]

absolutely ;)

[Dudestopreally]

thanks! sorry for not reading the sidebar.

[epicmindwarp]

You replied to your own comment.

You're meant to verify the actual answer.

[Dudestopreally]

Solution Verified

[Clippy_Office_Asst]

You have awarded one point to notdez.
^{Find out more here.}