Index Match function to pull values only including multiple exact criteria

WS attached

Main project for reference :
I have a dataset of thousands of bond orders through our desk. I am trying to make a interactive search to pull all bonds related to certain attributes from the order. For example: insert a cusip or user and have it pull bonds they might buy based off of past trades and types of bonds they purchased (through the criteria system)

Lookup:
But as of right now, I think I need a type of Index(match function to properly pull all values related only if ALL of these conditions are met (the same as the ones we are looking for): Composite Rating, Maturity Year, Industry, and Sector

Attached is a ws with an example from the data with more description, any help would be awesome - thanks

Have you seen this thread? It is almost exact: you could be co-workers.

https://www.excelforum.com/excel-gen...-searched.html

Nice try, Travis!

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...-searched.html