Thread: need help with conditional vlookup formula

I don't know if I'm going about this right, but I need a conditional formula that will look at a series of data and then for any transactions with the same number return the latest date. I have a sample set of data, but my real date is over 30,000 lines. My ultimate goal is to be able to combine the same transaction numbers to one line. I know I can do that with a pivot once I get the latest date on all the transaction. I have included my sample, I took a stab at it, but I would need the formula to look at like transaction numbers and pull the max date from them. Let me know if you need more clarity.

Try this array formula

=MAX(IF(A3:A20=A3,K3:K20))

commit with Ctrl-Shift-Enter

Thanks Bob, That works great, I added my other condition to it, and now I can pivot. Thanks for your help
Formula looks like this now:

=IF(E3=0,L3,(MAX(IF($A$3:$A$20=A3,$K$3:$K$20))))