multiple results

  1. S

    Return multiple results based on a variable cell.

    Hi, I want to use the value of a drop down box (already setup) to produce a list of identifiers from another sheet. In the 2 screenshots, the yellow box of the timeline tab will be a drop down box, this will be the responsible units. I want to select a responsible unit and all the ID names...
  2. H

    Return multiple results from duplicate name and date range lookup

    Hello Forum I am needing some assistance bringing back multiple results into one cell if a match is found based on a name match and a date falling within a range on another sheet. Sheet 1: this is my results sheet Column A = list of names Column D = start date Sheet 2: this is my lookup sheet...
  3. M

    Using Index/Match or Vlookup to get one result out of multiple results

    Hi there. My very first post here. I'm an intermediate Excel user and have been working on a project. I have a problem where I am using Index and Match formula to index one result (Using Match formula to determine both the row number and the column number in the Index formula). The problem is...
  4. M

    Lookup with multiple results but only once

    I have a list of vehicles that are scheduled for maintenance work over 8 columns and 1873 rows (including the header). Each vehicle is assigned to a department. Column 'A' has the week number Column 'G' has the department If I enter a week number in cell J1 i am hoping to generate a list of...
  5. K

    Return multiple lookup results in different cells

    Hello, I'm trying to essentially do something similar to a vlookup, but instead of it just returning a single result, I want to see all results. I would like to have each result show in a different column. Here's what I have in mind: Basic Data Set <colgroup><col width="64" span="2"...
  6. T

    Return Multiple Rows of Data without Arrays

    I've got a large table of values, 5000+ rows long, and about 20 columns wide. In that table are multiple items with the same partner name. I need to pull all of the entries out of that table for a specific partner. There may be anywhere from 1 to 20 occurrences of that partner name in the...
  7. B

    VBA: Range.Find returning multiple results

    Hi, I'm working on a project where I need to lookup a name from a list, and then navigate to a worksheet with the same name. I've got this working fine, however when there's multiple matches to my search, Range.Find just finds the first instance and keeps going. So for example, I could have...
  8. S

    multiple results, multiple criteria - is there another way apart from arrays?

    Hi out there! I would like to provide a search function, based on two values. If it was a sum, I would be fine, as I would use sumproduct, however I am trying to return multiple results which are not sums. I would like to attach a sheet - this would be the easiest way of explaining how to do...
  9. E

    search array and return one or more column headings as results

    Hello. I am a first time user. I can usually search for what I need and adapt the solution to my situation but this challenge has me wanting. I have a set of data that I would like to search as a set of columns or an array and I would like to return the results of each occurrence to a cell or...
  10. L

    Array formula, multiple conditions, multiple results

    I am trying to find a formula that will return the data for corrective actions that are repeat issues that are within a date range. I have a summarty table that will contain the repeat issue data once it is pulled from my main table. So I need the formula to look at my main table (contains...
  11. G

    How To Return Multiple Match Values in Excel

    Hello all, Recently i downloaded a template from Microsoftoffice, which helps me to organise the weekly task. https://templates.office.com/en-us/Weekly-task-schedule-TM00000010 However, when i add more than one task on the same day in the spreadsheet (task list), excel only return the first...
  12. M

    Vlookup return multiple items in row horizontly

    Dear All, I have gone through the web and found very useful working samples/examples for my query in which they used index small row and combination of such formulas. but as noob I couldn't figure out the logic and resulted in no solution for my problem. I have bunch of data in sheet "Daily...
  13. L

    Returning Multiple Values Through A Vlookup - Formula or VBA

    Context: I regularly use Vlookups in my work as part of a project, but as you may be aware, they can only return one value from the lookup column. For month-end reporting I need to determine if a particular account as a record in the relevant system inboxes, if it appears in more than one...
  14. J

    Match and return multiple results in one cell

    I have a spreadsheet of students assigned to a specific teacher on a specific day for tutoring and I would like to create a single sheet that list all teachers individually in a row and then shows the students assigned to them for each day. I have tried VLOOKUP, MATCH, INDEX with no luck. Data...
  15. L

    VBA Using LARGE to find Nth Number and return .ROW

    Hello all. I have a project Dashboard that needs to refresh the Daily Numbers in order of Order Volume. Then, after I supply the number, I want to application.worksheetfunction.match/index the client associated with that Nth Large number. Only match/index isn't working for me as there are...
  16. W

    Index-Match/Small based on multiple criteria

    So I've gotten the basic search to work: {=INDEX('Combined Data'!$A$2:$C$1000000,SMALL(IF('Combined Data'!$B$2:$B$1000000=$B5,ROW('Combined Data'!$B$2:$B$1000000)),ROW(1:1))-1,3)} Right now, it's looking just at the $B column of the array, and as it's a huge array with up to 30 instances of the...
  17. S

    How to reference a cell to get multiple data in a named range

    Hi, I've been trying to find anything related to my question but all I get is multiple results that match the same reference. Ex. If a have <tbody> Name Color John Green Dave Red Matt Red </tbody> I would look for red and I would get "Dave" and "Matt". What I am looking for is: If...
  18. P

    Attempting a Search Box with Multiple Results

    Hello, I'm trying to perform a 'search box' function in my excel workbook that will display multiple results if necessary. I have a workbook with 27 pages in it, the first is a cover/title page of sorts and the others contain tables with text - each other page relating to a different letter of...
  19. E

    Ignore blank cells on matched values with multiple results

    Excel 2013 Windows 10 Surface Pro 3 I am creating a training database where each employee has a training sheet and then I have a summary sheet that looks at each individual sheet, determines if the training is past due, and returns the name of the necessary training course. Example Training...
  20. I

    Yet another INDEX & MATCH question

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top