Multiple search criteria to return multiple results

**johnmacs5** · 08-30-2016, 02:15 PM

i have a spreadsheet that holds information on bin locations, i need to be able to query all bin locations that meet a specific product code and lot #. i can get the first available location row but not the subsequent locations. The chart data is in b3:d42, column b holds the product code, column c holds the lot information and column d holds the bin locations. the index match formula is as follows; { =INDEX($B$3:$D$42,MATCH(1,($B$3:$B$42=$AO$3)*($C$3:$C$42=$AP$3),0),3)}, how do i fix this so that it will return all bin locations in a new chart?

**JeteMc** · 08-31-2016, 09:22 AM

Without a spreadsheet to go by it is hard for me to know what you want as for as how the output should be formatted. To attach a sample spreadsheet. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, you can put them in manually. Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

That said take a look at the attached spreadsheet and see if the INDEX/SMALL array entered formula is yielding results similar to what you are seeking.
Let me know if you have any questions.

**johnmacs5** · 08-31-2016, 05:03 PM

Thanks for the response, not sure that i got the attachment, it opened a window in a separate window. the data highlighted in yellow was entered manually to illustrate how i would like to set it up to draw the data in.

**JeteMc** · 08-31-2016, 06:02 PM

Take a look at the 2A column which is populated with the following array entered formula* See if this is something that you think you could use with the other columns:

Formula:

Please Login or Register  to view this content.

*Array entered formulas are activated by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let me know if you have any questions.

**johnmacs5** · 09-01-2016, 12:14 PM

Worked beautifully, Thank You for the assistance

**JeteMc** · 09-01-2016, 05:17 PM

You're Welcome, thank you for the feedback and marking the thread 'Solved'. I hope that you have a blessed day.

Multiple search criteria to return multiple results

LinkBack

Thread Tools

Rate This Thread

Display

Multiple search criteria to return multiple results

Re: Multiple search criteria to return multiple results

Re: Multiple search criteria to return multiple results

Re: Multiple search criteria to return multiple results

Re: Multiple search criteria to return multiple results

Re: Multiple search criteria to return multiple results

Thread Information

Users Browsing this Thread

Similar Threads

Search multiple columns for with multiple input for search and return all results

Multiple Search Criteria produces (list) Multiple results in a single cell

Search Workbook for cells that meet multiple criteria and return results from rows

Select multiple criteria and return multiple results

Search multiple sheets and return list of multiple results

User Form to Search multiple Criteria to return multiple Results

Multiple Search Results of Multiple Criteria

Bookmarks

Bookmarks

Posting Permissions