Copy in order

  • Thread starter Thread starter Udayan
  • Start date Start date
U

Udayan

In Sheet1 - I have a crew list in joining order, for example
Bunk Name
101 name-a
108 name-b
103 name-d
105 name-f

In sheet2 – I have a bunk list in bunk order

101
102
103
104
105
106
107

Is there any formula to look up sheet1 and copy the corresponding names and
place in sheet2 corresponding columns, for example like this?

101 name-a
102 blank
103 name-d
104 blank
105 name-f


Please help me.
 
Hi,

You could just sort sheet1 by Col A.
Or if you don't want to do that,
In the cell B2 (next to 101) on sheet2, ente
=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$B$10,2,0)),"",VLOOKUP(A2,Sheet1!$A$2:$B$10,2,0))
Then copy down.

I have assumed that your data starts on Row 2, and is in Cols A and B
Change the Range to suit your data.

Regards - Dave.
 
Back
Top