Min and If Statements Combined with VLookup?

[JohnSlider]

Hi,

VLookup is probably not the right starting point, but it's the best way I can describe what I'm trying to do.

Store	Y/N	Sales	Formula 1
Best Buy	No	4	No
Target	Yes	5	Yes
Target	No	3	Yes
Best Buy	No	9	No

<tbody>
</tbody>

Formula 1: Search for any "Yes" entries in column B, if at least 1 is present for the store listed in column A, then it enters "Yes" in column D on every row for that store.

Store	Y/N	Sales	Formula 2
Best Buy	No	4	4
Target	Yes	5	3
Target	No	3	3
Best Buy	No	9	4

<tbody>
</tbody>

Formula 2: Search for the MIN entry in column C based on the store entered in column A, and return that MIN entry on every line for that store in column D.


What do you guys think? Doable?

 

[Aladin Akyurek]

In D2 enter and copy down:

=IF(AND(A2="best buy",B2="No"),"No",B2)

In E2 enter and copy down:

=MINIFS($C$2:$C$5,$A$2:$A$5,A2)

If MINIFS gives you the #NAME? error, control+shift+enter, not just enter, and copy down:

=MIN(IF($$A$2:$A$5=A2,C$2:$C$5))

Or just enter and copy down:

=AGGREGATE(15,6,$C$2:$C$5/($A$2:$A$5=A2),1)

 

[JohnSlider]

Excellent! Thank you!

 

[Aladin Akyurek]

Excellent! Thank you!

You are welcome.