1. D

    Matching based on rows

    Hi everyone, I am looking to create a formula (I am assuming using Index & Match & IF??) that will provide me with a text output (for later use in Pivot Tables) to indicate this data should be removed. As you can see in the picture, I've already got a column (column S) that refers to many...
  2. T

    Lookup Table in one sheet and Data in another

    Hi All, I have a data in one sheet in the workbook that in column A, it keeps track of individuals names, in B, the dates that they came into work, and in C, which shift they worked (work is divided in 3 shifts M, A, or E). I want to create another sheet, where one person's name can be typed...
  3. Jyggalag

    Iferror(Index&Match&Match) formula

    Hi all! I currently have a large worksheet that is similar to this: With the master data looking like this: I want to create a sort of IFERROR(IF(INDEX=0, ,MATCH and MATCH formula (with an iferror that returns "" (blank) if there's an error)) for every column with [] such as [DATE]. So...
  4. M

    Vlookup to return date from data sheet if between certain date range.

    Hello all, I have a two sheet workspace. Sheet 1 is called Data and sheet 2 is Print Dates. In Sheet 1 I have in multiple columns three sites. Site 1, 2 and 3. Site reference is found in row 3. Columns A4:A80 are dates for Site 1, Columns C4:C80 are dates for Site 2 and Columns E4:E80 are...
  5. C

    Vlookup, Index & Match - Grab values and compare

    Greetings to all. First of all, I am new to this forum and need the help of your excel knowledge. I have a workbook with the Sheets: A, B, C. On the B sheet I am collecting data from sheet A, and trying to collect other data from sheet C. Since the VLOOKUP wont collect negative col_index_num...
  6. Jyggalag

    IndexMatch function not working, please help :)

    Hello everybody, I currently have something similar to this: Linking to this: It should return the date 21-06-2019 for XG10, but it does not. Can anybody see what I did wrong and how to fix it? Would be greatly appreciated! :) Thank you! Best regards, Jyggalag
  7. E

    Sheet Name But Referencing Column Letter

    Hi, Overall I'm trying to use a filter function with data from a separate sheet. Problem is the data is not very consistent and the column headers move around. I can use the address and match to find my column letter in the other sheet but I want to be able to put it back in to an overall...
  8. S

    Multiple Criteria Multiple Worksheets Find Match Lookup place on Summary Page

    Need a summary page that pulls data from multiple worksheets in the same workbook. Each day an excel spreadsheet that has device readings is created and saved in a folder. The devices have unique identifiers. There are 20 devices. I have used a macro to place all of the sheets in one workbook...
  9. L

    Using INDEX MATCH to sum over a range, now wanting to add in an 'if' in to the formula

    Hi, Table 1 has many rows with costs in & in Table 2 I want to sum up these costs. Originally Table 1 did not have currencies in, so I was able to use the below INDEX MATCH formula to do this: =SUM(INDEX(2:6,N(IF(1,{1,2,3,2,5})),MATCH(C9,1:1,0))). Now I want to split the total of these 5...
  10. Jyggalag

    Excel not showing blank in formula when I want it to

    Hi all, I currently have this formula: Right now the cell is showing a blank cell. I then have another cell that links to this cell through this formula: This cell also shows blank, because the first cell is blank. I then have a third and final cell with this formula: However, this...
  11. Jyggalag

    Help with possible IFERROR(INDEX(MATCH))) formula

    Hello everybody, I currently have an excel sheet that looks similar to this (but much larger): And then a master data sheet next to it that looks like this: Please note that some of the titles are not in the master data set (in reality however, they all are, i just created this example...
  12. E

    Results disappear when match is no longer found.

    I have the following formulas in 24 different cells in my "Stage Times" sheet looking up certain criteria in my "Frac Report" sheet. They are correctly entering the matches they find in the "Frac Report" tab but then when the criteria is no longer found, the matching result disappears in the...
  13. M

    sort/match columns on same value and skip missing

    Hello, Im new here and i've got a question. I'm making a yearbook for students and i want to check if everyone has filled in the forms enquete. I download a forms sheet with the input from the students and now i want sort the data with my other excel (The excel with al the names) How can i...
  14. A

    Find first and last row that includes specific text

    In the column named Example it should show the time different between every status change and when the when status is CLOSE I want to do a time different between status NEW and status CLOSE. Hope you guys have some great answer to this question. :) Best Regards Ahlis
  15. H

    How to match 3 columns in 2 different sheets

    How is it possible to compare cells in 3 columns of 2 different sheets? The rows will not necessarily match up, but the column data will, so if A, B & C match in any row in the 2 sheets, then it is a yes. Let me explain. Column A is the name of the league Column B is the date and time of the...
  16. T

    Counting unique values with FREQUENCY, ISNUMBER, SEARCH, and MATCH - problem when adding date

    With below formula I am counting unique values. Everything worked well until I added the dates. Any suggestions to solve this? Picture attached =SUM(--(FREQUENCY(IF((N:N="Installer/Contractor")*(ISNUMBER(SEARCH("|"&I:I&"|";"|Visit|Online Meeting|Webinar|Join Visit|")))*(ISNUMBER(SEARCH("Ole...
  17. Q

    Get matching list between two columns

    I have two different brand lists in two different columns, New List and Reference List. I want to make a formula that returns only the matches between two columns, as shown in the table below. New List Reference List Formula Returns Brand D Brand A Brand D Brand Y Brand B Brand B Brand...
  18. L

    IF + MATCH + repeated values

    Hi, maybe some of you guys can help me out, i have the following table: Hour Event Disconnected at Time out 01:25:36 Ping down 02:25:17 Ping down 03:47:50 Ping down 04:50:50 Reconnected 05:20:14 Ping down 06:14:15 Ping down 07:08:55 Ping down 08:00:01...
  19. C

    IFERROR INDEX MATCH not pulling data when true

    Hello! I am having an issue with cells F5 thru F8. Cells F4 & F9 (directly before & after) are pulling the data, just fine... but F5 thru F8 are not. F5 thru F8 should be pulling the number 30. All cells are "general". Please see attached image/snip-it! Formula for F4...
  20. M

    Matching dates along with a lookup

    Hi all! I'm having some issues getting this to work (im a newbie) Im using a xlookup to look up someones name and return a daily stat - however the 2 sheets im using both have dates attached, is it possible for the lookup to return "the name with the stat if the date matches ? not sure how...

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
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 "".
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