1. J

    Vlookup not working with dragged down dates!

    Hey guys. I will try and explain this in as much detail as I can and hope you understand! So effectively i have a data set of around 370,000 rows of data, one row (price) for every minute of the year. However, there are many minutes that are missing and thus i need to flag them as missing by...
  2. I

    How to merge two formulas in to one formula

    Hello Excel specialists, I have two formulas I would like to merge: First formula =IFERROR(VLOOKUP($A8,List2!A:T,9,0),"Value not found") This formula is checking if cell value of A8 exists in List 2 Second formula =IF(ISBLANK(VLOOKUP($A8,List2!A:T,9,0)),"Empty",VLOOKUP($A8,List2!A:T,9,0))...
  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. 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...
  5. 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...
  6. 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...
  7. R

    IFERROR in Data Validation Formula

    Hi there, I would like to provide a dropdown list based on product categories for specific customers. Each customer has its own table, and if a customer doesn't have a specific table set up, formulas in the worksheet refer to a table "StandardTable". I've tested the following formulas in Data...
  8. 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...
  9. M

    Applying text data to all duplicates found in another column

    Hello, I'm trying to apply a set of comments from column F to column B. I'm unable to change the formatting of column A unfortunately. It would be preferable to have a Vlookup function in column B. Column A will always be variable in length, and column E should always contain the remaining...
  10. G


    Hello, I am doing a vlookup on one column's values which includes multiple data types (dates, number, or #N/A for not available. The one column's results will either be: 1) a date (formatted MM/DD/YYYY) 2) or it will be a number, positive or negative 3) or it will be not available (#N/A)...
  11. M

    How do I handle an IFERROR that returns blank instead of an error?

    Hi all, Thanks in advance for your help. My formula is below, I've staggered it to show the nesting a bit more clearly. The final Vlookup is not being triggered because my formula is returning blank =IFERROR( IF(V2="","",IFERROR( TEXTJOIN("...
  12. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  13. M

    VBA Vlookup - if part number not found then display Msgbox and Exit Sub

    Hello, I have following macro which on Error will resume to next. Now I want to display a message box if an error is found and after exit SUB Message box( "Part number" & "PN" & "not found. Please define packaging details") By PN should be displayed the part number that is not found. Sub...
  14. D

    IF function comparison

    Hi, In the file attached, there is the Group column (B) and Name column (C) both of which are related to each other. I need a formula that would return a value under certain conditions of what is inside columns B and C. If e.g. the column B value is USA, but in column C we have "wood and...
  15. D

    IF function with ISNumber(Search()) and Vlookup

    Hi! I am trying to write a function that would use two vlookups, where in the first vlookup there are also IsNumber(Search()) supporting it. What I have written looks like this - IF(ISNUMBER(SEARCH("part of text", d3)),VLOOKUP(D3, 'tab x'!A:B,2,false),VLOOKUP(D3, 'tab x'!A:C,3,FALSE)). As you...
  16. J

    IFERROR twice?

    Hi I have a simple formula I’m using to pull data from other tabs on a spreadsheet =IFERROR( VLOOKUP(A33,tab1,9,FALSE),””) This has been working fine until I now want to pull through data from a field that has a date in it. Now, if the particular cell it’s pulling from doesn’t have a date it...
  17. M

    % Change Between 2 Yrs with Iferror formula

    Hello I was hoping someone could please help with formula that I can't seem too get. I am doing a simple % change formula, if there is no value in column P/row 99 the cell in R99 shows blank. If have no value in column Q/row 100 the formula calculates with "-100%" I wanted the formula to also...
  18. L

    IFERROR formula

    Hi, Im working on a warehouse database with orders and quotes I have this IF formula =IF($B2="","",SUMIF(CheckOrderCommitted,B2, CommittedQuote)) But its giving me a $REF in all cells. This is because the cells reference too, Data is not in the cell., Im trying to do a IFERROR so that when...
  19. E

    Iferror VBA not working

    I have the following VBA formula, which is not working. if i just have the formula in a cell, it works just fine: Range("AI4").Select ActiveCell.FormulaR1C1 = "=IFERROR(RC[-3]/(RC[-15]-RC[-24]), "")" as a formula it would just be =iferror(AF4/(T4-K4), "")
  20. D

    Eliminate #DIV/0! with IFERROR

    Hi there I'm having a brain freeze with an IFERROR to eliminate the #DIV/0! after a simple calculation and it's driving me insane... the formula is =(E108-C108)/C108 the result of course where there are zeros is #DIV/0!. I have tried a few variations unsuccessfully any help will be greatly...

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