Copy in order
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.
|