Search for text in First set e.g Apple and Min value from the corresponding set

Below is my Query. I want to get an solution for this

A1(Apple), B1 (Grapes), C1(Apple), D1(Apple) are my first set of columns

E1(1.1), F1 (3.6), G1(6.8), H1(8.9) are my second set of columns

Want to search for the text in First set e.g Apple and Min value from the corresponding Cell value in second set

Expected output should be Min (E1,G1, H1) only Apple's min value'
Ans: Min (1.1,6.8,8.9)= 1.1
Please help me on this to write the condition in excel

Corrected the cell




EXCEL.JPG

If I understand the "either...or" part correctly the following yields the expected result: =AGGREGATE(15,6,I2:L2/(A2:D2="Apple")/(E2:H2="AA")+(E2:H2="BB"),1)
For future reference you will usually receive quicker responses if you upload a spreadsheet as opposed to a screenshot. To upload a sample spreadsheet or workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.

I hope that the attached copy of the file will address all the points made.
1. The formula from post #8 is applied to A6.
2. The following formula is applied to M3:P3 =IF(OR(E3="AA",E3="BB"),MIN($B6,I3),MIN($A6,I3))
3. The following formula is used as a conditional formatting rule in M2:P3 =A$3<>"Apple" (font > effects > strikethrough)
Let us know if you have any questions.

Hi JeteMc,

Thank you for your comments on my queries. Still one more combination i am analyzing on the formula to get it.

Please look into the attached excel and inserted comments in the output cells.

Awaiting for your inputs and directions

Thanks,Thiyag-Reply_1204.xlsx

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are quite new here, I have done it for you this time.)

I am confused as to why the O5 should be blank since C5 is Apple and G5 is AA.
I understand why P5 should be blank and to that end this modification seems to work:

Formula:

Please Login or Register  to view this content.

Note that this is a regular formula. Select cell M3 and paste the formula into the formula bar and press the Enter key. Drag the fill handle over to cell P3 and then (while M3:P3 are still selected) drag the fill handle down to P5.
Let us know if you have any questions.