Fetching cell value with multiple criteria

[Naveenaggarwal]

Hello !

I am facing some problem in getting result by formula. i am enclosing the sample sheet herewith.
Please review and revert back with correction. There may be something, i am unable to focus.

Waiting for the appropriate support.

Thanks
Naveen Aggarwal

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

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. No help to be offered until this moderation request has been fulfilled.)

Administrative Note:

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

[Naveenaggarwal]

I have revised it...please review once.

Thanks for guidelines

[AliGW]

Please uppdate your profile, as requested. 10 is NOT an Excel version - which do you have?

[Naveenaggarwal]

I am using Office 365 subscription product....Please let me know what else and how to update.

Regards.

[Naveenaggarwal]

I just did it....

Thanks for your support...

[JeteMc]

Modify the formula in cells B5 and down to read:

Please Login or Register  to view this content.

Modifications are highlighted in red.
Note that this formula may be activated by pressing the Enter key.
Let us know if you have any questions.

[Naveenaggarwal]

Hello JeteMc,

Thanks for the help and sorry for the delay in response/feedback. I tried to use your formula and found working however it is only working in first criteria only. other criteria, it is not working. Please see the red cells in my attachment and support me to resolve it.

Thanks in advance.

Naveen Aggarwal

[AliGW]

In B22:

=IFERROR(INDEX(F,AGGREGATE(15,6,(ROW(A)-ROW($1:$1))/((A=RIGHT($B$1,LEN($B$1)-FIND("-",$B$1)))*(B=RIGHT(LEFT($B$1,FIND("-",$B$1)-1),FIND(" ",LEFT($B$1,FIND("-",$B$1)-1))))*(E=B$20)*(D=E$20)),ROWS($A$22:A22))),"")

etc.

[Bo_Ry]

Please try

=LET(h,$B$1,FILTER(F,(A=MID(h,FIND("-",h)+1,99))*(B=MID(LEFT(h,FIND("-",h)-1),FIND("for ",h)+4,99))*(D=E3)*(E=B3),""))