Lookup Value in Combo Box and Return Multiple Lookup Matches

[troygeri]

OK - here is what I want to do - in the attached spreadsheet I want to lookup the numeric value in the drop down list (under the label Project ID & Name) on Dashboard Page - but prefix it with PP and then use it to lookup all matching rows in sheet ImpactDetails and return the Asset ID and Asset Values, so for example PP37222 would return 5 matches and these would be listed in the dashboard page where I currently have #NAME? being returned. I was assuming I would end up with some sort of INDEX formula that I would paste down the page and return a blank if no match and a Asset ID and Asset where it does match. Any help would be appreciated - excel is here

https://www.dropbox.com/sh/x1i4yl9juii3b1o/AABj-8sfXj-sVSuZ6bLatBiTa

 

[skywriter]

You have to right click on your combo box select properties and LinkedCell and then link a cell to the combo box. You can put it somewhere out of the way, but I used J10 so you could see what I did. Then use the array formulas I have shown to get you going.

Excel Workbook
	H	I	J
10	Cards Intranet IOD Migration		37222 Cards Intranet IOD Migration
11	Cards Intranet IOD Migration
12	Cards Intranet IOD Migration
13	Cards Intranet IOD Migration
14
Dashboard