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.