Match values from two columns

[Guest]

Hi
I have two tables with a number as common key. The first table contains a
subset of the numbers in table 2. I like to sort the rows in the seccond list
based on the matching the number in the first list. How to do it in Excel
2000 ??
examle:

table 1 table 2 Result

Number1 | Name Number2 | Price Number1|Price

 

[Frank Kabel]

Hi
not really sure how you want to sort. Do you want the matching values
in table 2 at the top??