CODEWITHSUNDEEP
excelexcel-formulavlookup
Ufo_Pilot
Ufo_Pilot

Reputation: 3

Copy one row to multiple rows on another sheet

I have a sheet with multiple project numbers: Sheet1

enter image description here

I have another sheet with the same project numbers but with more information: Sheet2

enter image description here

What I need to be able to do is quickly copy the information on sheet two to sheet one filling in the correct information to the correct project number

I will have hundreds of rows to fill out, so I would like to find an efficient way to populate the rows.

Upvotes: 0

Views: 256

Answers (2)

Judith Palacios
Judith Palacios

Reputation: 413

you can use VLOOKUP funtion to fill with the data

ex. put in Sheet1 B1 as follow

=VLOOKUP(A1,Sheet2!$A$1:$D$5,2,FALSE)

then in C1

=VLOOKUP(A1,Sheet2!$A$1:$D$5,3,FALSE)

and D1

=VLOOKUP(A1,Sheet2!$A$1:$D$5,4,FALSE)

change to your range and fill down

Upvotes: 0

user4039065
user4039065

Reputation: 

=VLOOKUP(A1, G:Z, COUNTIF(A$1:A1, A1)+1, FALSE)&TEXT(,)

Fill down.

enter image description here

Upvotes: 1

Related Questions