I have a table with a number of system options and their associated characteristics (including price).
The last column of my table is a data validation column, with the option to include (options are 'Yes', 'No').
I need to return the system options that have been selected as 'Yes' into a different table, and include their associated cost.
I want to avoid Macros and I've been look at VLOOKUP, INDEX-MATCH and so on but can't figure out how to return multiple matches.
I have a feeling its quite a simple solution. I've attached an example of the problem - thanks in advance for your help!