Index offset I think (Thanks In Advance)

[nehpets12]

Book3
	A	B	C	D	E	F	G
1	Date	Qty					AnswerLookingFor
2	Monday	7			Monday	HowdoIFindHighestQtyThatMatchesMonday	7
3	Monday	2			Tuesday	HowdoIFindHighestQtyThatMatchesTuesday	4
4	Monday	3
5	Monday	4
6	Monday	5
7
8	Tuesday	1
9	Tuesday	2
10	Tuesday	4
11	Tuesday	3
12
Sheet1

 

[s-o-s]

Hi Nehpets12,

This can be done with an array formula. The formula from cell E2 is Entered by Holding Ctrl + Shift and then hitting Enter this will put the braces around the formula and make it give you the correct value.

Book1
	A	B	C	D	E
1	Date	Qty			Highest
2	Monday	7		Monday	7
3	Monday	2		Tuesday	4
4	Monday	3
5	Monday	4
6	Monday	5
7
8	Tuesday	1
9	Tuesday	2
10	Tuesday	4
11	Tuesday	3
Sheet2

 

[Daniel Stefan]

Probably, you've already received the answer:
Using a formula array(CSE)

 

[eliW]

Hi nehpets12,

Array enter in G2 the formula:

=MAX(IF($A$2:$A$11=E2,$B$2:$B$11))

and copy down to G3 and so on.

Dont forget it is an ARRAY formula you must press CTRL+SHIFT+ENTER

Eli