View Single Post
  #1   Report Post  
pek
 
Posts: n/a
Default 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