hi,

i have the following:

=MATCH(AC2,sheet2!B2:sheet2!B63001,0))

but the only thing is that there a lot of duplicates of what is being looked
for. i would like to know how i can deal with this, and make sure that the
LAST match number is given.

thanks in advance,
geebee