I'm looking for the last occurance

See attachment.

I'm using the =LOOKUP(2,1/($C:$C=I1),$A:$A) formula... And everything works fine except for H9 and I get the #NA while it is #4140 (or line A20). What I'm I doing wrong?

Thanks ahead of time for your help...

Thanks for your quick reply and help...it works great.

Though when I apply it to my master file (where I have 4500 entries it still doesn't work. (Regarding the "Text" for 88. I use it because of the "00"). Maybe I have just too many rows and not enough power coming outta my computer??? Just don't know.