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
Bookmarks