Hello all -
I am attempting to create a report that where I choose a FICO number in a dropdown menu and it brings up all scenarios where that FICO number appears.
For example, if I have the FICO score of 800, and I have 5 scenarios of 800, I want to see the all the data for the 5 scenarios that appear in my spreadsheet.
I initially thought of VLookup, but it only brings up the first instance. I need all instances.
Any help would be appreciated.
Thanks.
Dave
Bookmarks