Believe index/match would serve your intents (the data need not be sorted)
For starters, try Debra Dalgleish's nice coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH
There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Russ" wrote:
Hi folks,

I need to compare data on a weekly basis. The problem is that new entries or
unique identifiers are also created every week. So if I sort it by name, the
list never matches cause new entries are there. How do i match new values
when the list adds on new entries?

Russ