Match values from two columns
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"pek" schrieb im Newsbeitrag
...
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