I am very sorry sir, but i did as you told me, but no luck. Here is a link for the excel workbook with your formulas typed in
http://www.2shared.com/document/w0YcE7g3/Sort-local-lists-and-match-to-.html
Kaushik
Thank you.
I tried the following. In the L1 cell master sheet 1, i typed ShtNames, left of the fx symbol on the formula bar and also labelled it ShtNames. Underneath it, in cell L2-L7, i typed
Mechanics
Field Engineers
Sales Force Office 1
Sales Force Office 2
Delivery Service...
Here is the link for the demo excel workbook
http://www.2shared.com/document/cKkxSjSA/Sort-local-lists-and-match-to-.html
In a nutshell, four times a year, we are supposed to log on to a central database and enter the customer rating of our employees. In this example worksheet "Central...