Hey all,
I am running into this blockade and unsure where to go from here but have few ideas.
So basically I have a huge list of Data and in theory I would like to search an ID Number from the data and pull all the data similar to the searched # based off of certain criteria all together.
More specifically, Is there a way to use my search in the "search" tab to search an ID# and pull all other ID numbers based off of the criteria of matching Maturity years and ratings.
Ex: Pulling the # in B2 which has the relationship of a 2023 maturity, Baa2 and BBB+ ratings and having a dynamic list display the others matching the same criteria of 2023, Baa2 and BBB+
I was thinking about using a form of Index Match, but have never used multiple criteria like this. My file should be attached
Any help would be awesome and really appreciated
Thank you
Bookmarks