Sort based on another sheet values

**naflas** · 07-14-2011, 03:04 AM

There are 3 sheets in the attached document. I want to sort sheet 2 based on values in the sheet1 . Once it has got shorted, the values order in the sheet 2 should be same as sheet 1. Additional values that are not in sheet 1,but in sheet 2 should be listed at the end.

In other words the output should be same as in sheet 3.

Please help me on this

**Roger Govier** · 07-14-2011, 03:40 AM

Hi

I would use a helper column on Sheet2
I inserted a row as a header row first to ensure that all values took place in the eventual sort.

In cell C2 enter the formula
=SUMPRODUCT((Sheet1!$A$1:$A$9=Sheet2!A2)*(Sheet1!$B$1:$B$9=Sheet2!B2))

Then select column A:C and sort by
Column C Descending
Column A Ascending

see attached file