The first LOOKUP() formula should pull up the last occurance of the lookup value... which I presume is the same for all duplicates....so shouldn't matter.. or does it somehow?