VLOOKUP to find latest date based on criteria in another column

[craigg3]

I am trying to get the latest date from column B if the text in column A =Hamburger. I would like to return the result in cell C1. For the below example, it should return the date of 6/25/2022, im just not sure how to make that happen. Thanks.

Example:

FOOD (Column A)	DATE (Column B)
Hamburger	4/5/2022
Pizza	5/23/2022
Sandwich	7/5/2022
Hamburger	6/25/2022
Fries	3/28/2022
Hamburger	5/1/2022

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[craigg3]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Sorry, currently using 2013, windows platform. Thanks.

 

[etaf]

EDIT

sorry - missed the reply

=MAX(IF(($A$1:$A$20=D2),$B$1:$B$20))

not sure what version of excel you have

MAXIFS()

Book2
	A	B	C	D	E
1	FOOD (Column A)	DATE (Column B)
2	Hamburger	5/4/22		hamburger	6/25/22
3	Pizza	5/23/22
4	Sandwich	5/7/22
5	Hamburger	6/25/22
6	Fries	3/28/22
7	Hamburger	1/5/22
Sheet2

Cell Formulas
Range	Formula
E2	E2	=MAXIFS(B2:B7,A2:A7,D2)

2013

Book2
	A	B	C	D	E	F	G
1	FOOD (Column A)	DATE (Column B)					2013
2	Hamburger	5/4/22		hamburger	6/25/22		6/25/22
3	Pizza	5/23/22
4	Sandwich	5/7/22
5	Hamburger	6/25/22
6	Fries	3/28/22
7	Hamburger	1/5/22
Sheet2

Cell Formulas
Range	Formula
E2	E2	=MAXIFS(B2:B7,A2:A7,D2)
G2	G2	=MAX(IF(($A$1:$A$20=D2),$B$1:$B$20))

 

[Fluff]

Thanks for that, how about

=MAX(IF(A2:A100="Hamburger",B2:B100))

This will need to be confirmed with Ctrl Shift Enter.

 

[craigg3]

Works great! Thank you all that offered suggestions.

 

[etaf]

you are welcome

 

[Fluff]

Glad we could help & thanks for the feedback.