match

  1. R

    Vlookup help finding closest date after reference date

    Hi I need help filling out the highlighted colum. The goal here is to fill out in Sheet 1, Column C "Closest After Dates in B", with the closet date after column B "Date signed up" by vlooking up to sheet 2 column B "Time", with criteria that Type is either "email", "outbound" or "inbound". I am...
  2. W

    offset, match index?

    I have a output from an accounting product and I need to reformat the table. At the bottom starting at row 23 you can see an example of the new worksheet I am trying to create. Can I get help with a formula to help automate this? The original report has 742 more accounts like this I need to...
  3. T

    Function that will collapse 4 rows of data into one row based on the first two columns information.

    Hi All, I am currently working on making a workbook that takes data from a data base and consolidates it down to a easier read. I currently have a system that shows when people call into our system, the problem is that this system creates a row of data for each entry and I would like to take...
  4. K

    Fill by matching and adding rows for multiple matches

    Hi! Unfortunately, my xl2bb still refuses to work (blanked out in the excel toolbar) but I'll save that for another post and just attach images here. I also previously posted the same thread but with very unclear and messy parameters so I'm redoing that here, apologies for that. The Sales...
  5. K

    Index/Match multiple hits of same cell value and add rows to fit spill

    Hi guys! Not sure how to approach this - with lookup and aggregate, an index/match sub or something else. So In the sheet called Empty, when B2 is filled, it populates the Invoice column in D4:D with unique invoice numbers from an external order sheet. The Sales sheet has a list of orders where...
  6. R

    Find matching string and get string of data in offset cell from raw dataset

    Attached is a screen cap of the imported dataset. Please note how the data is grouped with multiple labels and values in a single cell. I need to find the match JSN code which is located in a single cell along with miscellaneous data. The "JSN" text has (4) spaces after followed by the (5)...
  7. R

    Match columns in SUMPRODUCT INDEX MATCH formula

    I have two worksheets. One has the source table: And another has an aggregation table: To get the numbers from the first table to the second I use the following formula: =SUMPRODUCT(INDEX(FS!$A$2:$Z$250,0,MATCH(C$1,FS!$A$1:$Z$1,0)),--(FS!$B$2:$B$250=$A2))/1000 It basically checks the...
  8. L

    Index Match only returns first match

    =SMALL(INDEX(detail_check_payment!$A$7:$AA$358,MATCH("S&P ",detail_check_payment!$AA$7:$AA$358,0),1),ROWS(AA7:AA7)) When I use the formula above it only returns the first value that matches and I need it to return a list of all that match.
  9. N

    Multiple Ifs?

    Hello I would appreciate some help with a spreadsheet I have. I am trying to determine the responses from a survey that is sent out weekly. The respondent reply options are Yes or No, but I would also like to record if they dont respond. I have Sheet 1 where the survey results are pasted...
  10. A

    Index(match(),match()) with a partial search

    Hi all, I am trying to use a partial text search in one of the matches and it is not returning any results. I've used this method numerous times in the past but never with a partial search. Can someone please take a look at my example below and let me know if they can help? In my example, I...
  11. H

    Merging Match and Split Formulas

    Hello Do you think that would be possible to merge both formulas/functions in order to obtain my ColumnLetter value ? If so, what would be the proper syntax? Dim ColumnNumber As Long Dim ColumnLetter As String ColumnNumber = WorksheetFunction.Match("Column Name", Rows("1:1"), 0)...
  12. Jyggalag

    Hide sheets so you cannot see them without the password

    Hi all, I have an open workbook with three sheets called "1", "2", and "3". I want to hide these sheets and make it so that you cannot open or view them without a specific password. Right now, I can protect these sheets. However, protecting them means that you can still click on the sheets...
  13. M

    Conditional Format not acting as expected.

    I have the following. BC33Pos test (dupes)Other field test34113512B34:C35Expression=IF(COUNTIF($B$34:$B$35,B34)>1,IF(COUNTIFS($B$34:$B$35,B34,$C$34:$C$35,"<>")>=2,TRUE,FALSE),FALSE)textNO I would expect each cell to be highlighted, however C35 does not seem to be affected. The theory behind...
  14. P

    Compare tables and find closed date prior to selection

    Hi All, I'm currently doing scientific work and i can't find a way to find to match 2 table to find the closest date prior to the selection. I was wondering whether you experts can help me. As the data i'm working with is confidential i'm making a dummy table to show what i would need. What...
  15. welshraz

    Formula Help

    Hello, I am pulling my hair out as I cannot see the issue with this formula: =INDEX(CombinedNOI[OBJECTID],MATCH(MIN(SQRT((CombinedNOI[Lat]-U13)^2+(CombinedNOI[Long]-V13)^2)),SQRT((CombinedNOI[Lat]-U13)^2+(CombinedNOI[Long]-V13)^2),0),1) It was working perfectly until I linked it to a...
  16. A

    Index((match(),match()) greater than issues

    Hi everyone, I've looked and found several posts about using the greater than match type in index(match formula's but none have any with 2 match references and I'm stuck. I am building an AQL inspection table and want the sample size to be automatically indicated for our team however the value...
  17. F

    Top-10 list with ranking scores...I can't get it to work

    Hi everyone, I’m new here and this is my first post. I’m trying to build a simple risk registry to rank my risks. I’m not that skilled in Excel, but I have tried as much I can. I have now reached my limit of knowledge trying to build several top-10 lists. I think I have managed to build one...
  18. M

    Conditional Formatting based on specific text in a column and it's related values in another column

    Let's say I have a dropdown with two options (A2): Category 1 Category 2 I also have a range of cells given with different phrases: (A4:C5) Phrase A Phrase B Phrase C Phrase D Phrase E Phrase F and also a table which looks like this: (A6:B12) Phrase Category Phrase A...
  19. G

    What is fastest formula and input setting between INDEX-MATCH, INDEX-XMATCH, and XLOOKUP?

    Has anyone tried more detail about speed test for value lookup formulas? I tried myself but I doubt my experiment. Please see my screenshot. The lookup formulas to compare: (1) INDEX-MATCH, (2) INDEX-XMATCH, (3) XLOOKUP. Formula setting to compare: (1) whole column vs fixed range reference...
  20. L

    Put an IF statement inside of a MATCH functin?

    Hi everyone, I am attempting to create a function that searches an array for a date match, and if there is one, then subsequently check to see if a the time is between a designated "Start" time and "End" time within the row that contains a match. This function will be placed in the RUNNING...

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