multiple results

  1. 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"...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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>...
  17. J

    Match Index two criteria and return multiple values

    Hello, I am currently using the below formula: =INDEX($B$40:$B$404,MATCH($B$5&$B$11,$C$40:$C$404&$D$40:$D$404,0),1) I am matching b5 & b11 from cascading dependant drop down lists. It works to return the first value I need in column B, but when I copy it down it still returns the same value...
  18. J

    Compare two lists and return multiple values

    Hello, I am trying to compare Column A in the sheet "Craigslist" to Column A in the sheet "VPDC Server Data" and then return all the names from Column G where the two match in a new sheet titled "Craigs VM List" in Column B. I would also like to return the corresponding "Craigslist" Column A...
  19. R

    Help on setting up a search page

    I am trying to setup a search page in a worksheet on a document. I want to be able to search by an indicator (DID#), but there maybe multiples of the same (DID#) in the data. I want to be able to have each instance of the multiples displayed on the search page. In addition, I want to reference...
  20. M

    VLOOKUP with CONCATENATED result (col_index_num)

    Hi there, I am trying to figure out how to perform a VLOOKUP and return a concatenated result from multiple columns on the matched row. Below is how I want the data to end up looking: Result Worksheet <tbody> A B C 1 Full Name Phone Address 2 Joe Smith 1234 123 Gumdrop Lane, Gummie...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top