multiple matches

  1. S

    Sum index match multiple row multiple column - referring to an old post link inside

    Sum INDEX-MATCH Across Multiple Columns with the Same Heading Hello - how - wondering if someone knows how to modify this formula to account for multiple rows could be a match? Same Data but now multiple rows and multiple columns match? instead of...
  2. R

    Geeting multiple matches against same amounts in Excel.

    I would like to get all values matched the Green marked Bank Name column, but it isnt working. I need a swift, easy and permanent solution. BTW the I am working with is huge. its just for a demo. Please help.
  3. G

    Return multiple matches with multiple criteria as text

    Hey, I have read some similar threads here and tried some of them but still no solution for me. I have a large database where I would like to list all destinations of each driver for certain days. The main challenges are 1. any driver can appear in any of 3 columns, 2. there can be more than...
  4. S

    Returning values for multiple matches without array formulas

    Hi guys, I am looking to effectively extract multiple matches without array formulas as the lookup array for the multiple matches is large and slows down my workbook too much. I have the values, lets call them 'account names', I want to match with as column headers, the lookup column is in...
  5. S

    Index match question

    Hello! I am trying to make a sheet that pulls accrual values. I want to pull text based off of a cell that contains a company name. However, there are multiple lines with different accruals for the same company. I want to pull a specific result (not multiple result). i.e.- I have a carpet...
  6. C

    Indexing or looking up with two different criteria for multiple matches

    Hi all, I have two different measures (measure 1, measure 2), in two different spreadsheets (sheet 1, sheet2), with different values. These measures are carried out for each study participant (David, Maria and Bob) several times on different dates. I'm trying to bring together the dates of the...
  7. R

    Lookup set value, with multiple results.

    Hi all, I need help with a project i'm working on. I have a sheet where I need to find and print worksheets based on weather that PPM is needed to be completed that month. So for example, to Print all ppm's to be completed in week 6. I'd enter week 6 in the box and it looks up this week number...
  8. S

    Create Query Linking Two Tables Together

    Hello, I have two tables. One labelled "Records" and one labelled "Comments". I both tables I have an "Account Number" However in the records table, there will only ever be one record for each account. In the comments table there can be any number of records for that account. The idea...
  9. C

    Match data and copy row

    Hi, Sorry I'm new to VBA and having trouble with a macro. I have one workbook with two sheets (sheet1 and sheet2). Sheet one has a list of information in a number of columns and column A is the file number for each set of information. Sheet two has only file numbers. I'm looking for a macro to...
  10. K

    Find all matches for multiple conditions

    Hi, I am trying to find INVOICE ID for all Invoices shipped for each SKU after a certain cut off date. I have a list of over 1000 SKUs with multiple cut off dates for each SKU in Sheet1. The invoice shipments data along with the dates is in Sheet2. I have tried to create a Pivot table and used...
  11. Q

    Index Match (with multiple matches across multiple columns)

    Below is the formula that I'm currently using. When entered it returns error message: "Did not find value '1300' in MATCH evaluation". What am I doing wrong? The 'Bedrooms' column (S2) should equal "3 BD From". Please advise. Thank you...
  12. D

    Index, Match, when match data occurs in more than one row

    My brain hurts :) I hope I typed the match array correctly for this example. How do you change this formula so that the result in column E shows the next occurrence on the sheet when there is identical cells in the matching formula? I have a sheet with addresses I'm matching to another sheet...
  13. F

    Multiple Matches and lookups for a defined criteria

    Dear Excel Experts! I really need your help :) I have an excel file with many different orders. In the order two things are important: values in column C ASHEET (ending on A) and values in column D (components of Asheets). Now i need to analyse whether the component of an order is on ONE of...
  14. R

    formula(s) for Drop down list that returns list of possible materials in PO

    I am trying to design a PO that will "suggest" possible materials that match certain criteria. Our company orders many different types of metal components that make up steel buildings. The components have different shapes, finishes (grade and/or types of paint), colors and thicknesses (gauges)...
  15. G

    AVERAGEIF of SMALL with multiple criteria

    Hi all! Long time lurker...first time poster. I'm not an excel expert, but certainly not a noobie. So this is very, very frustrating. I have a very large dataset -- around 25K rows (probably more). I have a bunch of fields including STATE, AGE, GENDER, and RATING AREA. In addition, I have a...
  16. B

    Returning Smallest/Largest Value of Multiple Matches With Index-Match

    I am working on a pressure loss calc worksheet and need to have an index match formula return the smallest/largest value from the matches. I have replicated what a typical sheet would look like below. Each Pressure In cell has the formula...
  17. J

    How can I check that multiple cells have the same string?

    I want to check if cells C1, D1 and E1 contain the same name. For example if the cells all contain the 'Joe Bloggs' (or whatever the name variable happens to be) then cell F1 should say "Yes", else "No". Anyone out there who can help? Much appreciated!
  18. P

    VBA macros for multiple matches in different sheets

    HI I need a macros for multiple matches in different sheet and need to return the all values for unique id I put an example case for you Sheet 1 contains unique ids and values .Values will repeat In other sheet also values will repeats and will value corresponding values for the each...
  19. Q

    I am not returning the right information on this index function - can anyone help??

    <TBODY> A</SPAN> B</SPAN> C</SPAN> D</SPAN> E</SPAN> 1</SPAN> 2</SPAN> Markets</SPAN> Markets</SPAN> Location Name</SPAN> 3</SPAN> Select Market here ></SPAN> 058 - Total Canada Market </SPAN> 063 - Total Northeast Market</SPAN> 064 -...
  20. H

    Multiple matching & 2 conditions

    Column J (J17:J999) & column K (K17:K999) contains values. In column N starting with N17:N999, I want column K values PROVIDED J17= X1 AND K17 = Y1 AND J column does not have blank or null filled thr' a formula "" AND K column does not have blank or null filled thr' a formula "" How to do...

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
Back
Top