Find last entry in an array based on 1 criteria

**ryanh114** · 08-09-2010, 11:44 AM

In the attached example, I am trying to find the last entry for Batch# in Column O based on the Part# stored as text in Column D. I used the following formula [=IF(ISERROR(VLOOKUP((D7 & ""),$D$6:$O6,12,FALSE)),"",(VLOOKUP((D7 & ""),$D$6:$O6,12,FALSE)))], and it returns the first occurrence for any given Part# which is not what I need. I certainly appreciate any help you may be able to give!

**DonkeyOte** · 08-09-2010, 11:52 AM

Not entirely sure I follow the requirements but perhaps you want:

M7:
=IF(COUNTIF($D$6:$D6,$D7),LOOKUP(2,1/(D$6:D6=D7),O$6:O6),"")
copied down

**NBVC** · 08-09-2010, 11:54 AM

Perhaps?

=LOOKUP(2,1/($D$6:$D$21=D6),$O$6:$O$21)

copied down

you can hide 0's by custom formatting as 0;-0;;@

**ryanh114** · 08-09-2010, 12:23 PM

Thanks you both for you help, NBVC while this works as well, I am going to stick with the first response as it is a little cleaner without the conditional formatting.