I have read your message 3 times but still don't quite understand what
you are asking. Please try again with a more specific example.

The INDEX and MATCH worksheet functions might be useful.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup