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, enter
=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$B$10,2,0)),"",VLO OKUP(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.

Thanks Dave, Thank you very much

"Dave" wrote:

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, enter
=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$B$10,2,0)),"",VLO OKUP(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.

You're welcome.