iferror

Hi all, I currently have the following setup: I have marked everything that I want to be exported into a PDF, which works when I manually save the file as a PDF. However, I do also have a macro ("Save file to folder") as seen above, which saves the file (albeit as an Excel file) to my...

Hi all, I currently have this setup: I have a row of formulas saying IF(ISBLANK(cell below),return blank value, otherwise return value to the left + 7) to advance the week one week ahead when data is entered. I want to create a conditional formatting for this row, so whenever a value is...

Hi all! I have this formula: But for some reason, my formula does not work? I want my formula to return "NOT BLANK AND NOT 1" if the cell contains a value that is not = 1 and not a blank cell. If the cell contains the value 1 or is blank, i want my formula to return a blank cell. Can...

Hi, Is it possible to vlookup a cell that contains a formula? International code is internationalcode+lot# Hidden is a "hidden column" that contains a formula to only get the international code =left(B2,6) Local code is a vlookup of column C Product Name is a vlookup of column D Note: Not all...

Hi All, I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one. In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...

I have this formula I'm using to lookup style numbers from a table on another sheet (called Items) and input the description. My original formula was "=IF(F3="","",VLOOKUP(F3,Items!A:D,2,FALSE))" This worked great in that it removed the #N/A message if the cell was left blank and it looked up...

Dear all, I currently have this VBA code (please note the part highlighted in bold): Option Explicit Private Const FilePath As String = "\\COMPANY.SSSS.COMPANY.NET\userdata\t5382304\home\Documents\TEST folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i...

I'm trying to use a Vlookup function, but I want it to have multiple possible outputs. All of the other help I've seen seems to just want to outputs, an error, and a correct. I'm trying for three different outputs. I've tried searching for help multiple different ways, but I can't seem to find...

Hi! I have one master Excel (sheet "WP_Data") to which I import data (content from two separate cells and the Excel name) from tens of source-Excels. In each of these source-Excels I have sheet named "Workpaper_main", where I have a cell that is named as "WP_balance". I have the folder path on...

Hi I have been battling this one for hours! I have two formulae one that looks down Column E for specific text that is held in cell G2, the second looks down the same ColumnE for specific text held in G3. Both work well and return the value of the specific cell to cell E1. I have been trying to...

Dear all, I am currently trying to return some data from a larger database. I have created a test sheet that is very similar to the real sheet that I am working with, for the sake of privacy and making things easier to understand from an outside perspective. Currently, I have the following...

Dear all, I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel: I have the current sheet of data: The formula and the data links to this test sheet of data: Now I have done about 90% of the work (I hope), seen as my...

Dear all, I feel like most IndexMatch tutorials are very complicated. Does anybody have a good link or video that explains this formula, preferably with an iferror in front as well, understandable for a tech newbie like me? :) Thanks!

Hi All, I have been trying to use the iferror formula to show a certain number on my calculation. CURRENT FORMULA: =((A1*A2+A3+A4)) The formula should display 25 if the sum is less than or equal to 24. I have tried to integrate iferror statement on that existing formula but can't seem to get...

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

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

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

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

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

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