How to get most recent date through vlookup.

[max2599]

HI,
as you can see the image below i have some numbers in "B Column" i want to get most recent date of each number in "H Column" through vlookup. since i am using office 365 i have xlookup also...file attached



thanks




latest date.png

[AliGW]

Neither VLOOKUP nor XLOOKUP are required.

=MAXIFS($A$2:$A$84,$B$2:$B$84,G2)

You'll need to format cells as short date.

Please update your forum profile with MS365.

[max2599]

Thanks allot as it works perfectly, Can u add a condition if it doesn't find the number in columns it will give not found message. thanks

[AliGW]

Yes:

=IFERROR(MAXIFS($A$2:$A$84,$B$2:$B$84,G2),"Not Found")

You still need to update your profile, please.

[max2599]

I tried it but it gives following error. i highlight it in red color.

Attachment 739948

[AliGW]

Try this:

=IF(MAXIFS($A$2:$A$84,$B$2:$B$84,G2)=0,"Not Found"MAXIFS($A$2:$A$84,$B$2:$B$84,G2))

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

[AliGW]

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[josephteh]

Alternative solution using AGGREGATE: =IFERROR(AGGREGATE(14,6,$A$2:$A$84/($B$2:$B$84=G2),1),"Not Found")