View Single Post
  #2   Report Post  
vezerid
 
Posts: n/a
Default

In the first sheet, next to your data, add the function:
=vlookup(B2, Sheet2!$A$2:$B$10,2,0)

You can then sort by column C:C

HTH
Kostis Vezerides