Return multiple values based on multiple criteria matches

**simmo86** · 03-03-2014, 06:58 PM

Hey,

I have a spreadsheet that has a list of products and then 10 columns of features that state yes or no.

I am then trying to create another sheet that has a list of the features with a dropdown when you select 'yes' for each of them, it returns a list of all the available products.

I am wondering if anyone knows how this can be done via formulae rather than simply using autofilters? Reason being is that i want the results to then be looked up to produce further results.

Many thanks in advance!!

Alex

**JBeaucaire** · 03-03-2014, 08:52 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate what is needed. Make sure your desired results are demonstrated, mock them up manually to SHOW us what you want the results to be based on the sample data. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**tigeravatar** · 03-03-2014, 10:03 PM

Hello Alex,

Is there any reason you can't use the built-in Filter feature for something like this?

Return multiple values based on multiple criteria matches

LinkBack

Thread Tools

Rate This Thread

Display

Return multiple values based on multiple criteria matches

Re: Return multiple values based on multiple criteria matches

Re: Return multiple values based on multiple criteria matches

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to return multiple values to a single cell based on multiple criteria

Array formula to return multiple values based on various (OR) criteria

Lookup/ Return and concatenate values based upon multiple criteria

How to fill row based on multiple criteria with the most recent of multiple matches

Select multiple criteria based on check box selection and return all unique values.

Bookmarks

Bookmarks

Posting Permissions