isblank

hello I have this formula =INDEX(Holidays!$A$4:$OE$92,MATCH(O66,Holidays!$A$4:$A$92,0),MATCH($Q$54,Holidays!$A$3:$OE$3,0)) I need to include if O66 is blank, how would I do that than you Jason

Hi, I have a lot of dates from D3:D54. I would like to set up conditional formatting to show them red if they are past due. How can I make the blank cells not show any color format? I must be close but am just missing something. I've tried searching with no luck. ISBLANK(D3,"")=IF(D3<TODAY())...

Hello, I used the below formula to pull in the earliest date found in different cells...

I am still learning ISBLANK, IFERROR, etc. On the below how do I change formula that will return a blank result if Cell B5 is blank?

So I hope that I can explain this clearly. So I am trying to nest three formulas, IFERROR, VLOOKUP, ISBLANK. The goal that I am trying to achieve is use the vlookup function along with the IFERROR to not get N/A where there is nothing for the function to lookup. That has been achieved but, if...

Bit of a novice here so please bare with me. Trying to use an ISBLANK formula like so: =IF(ISBLANK(B26),"","Food Cost: "&B26) B26 is the cost of food. I want this formula to tie into a text line and reference both "Food Cost and cell B26 together. For the life of me and cant get this to work.

Hi guys, Newbie here! So I'm in the process of automating some tasks at work and am really new to VBA. I have a VBA code that finds a column header and then selects the data underneath this header upto the last row. From here I want to create an If statement to see whether the selection...

Hello from downunder (Sydney), Im trying to create an item master from approx. 8 spreadsheets. All in different formats. Most have duplicate unique identifiers (SKU code), but some sheets have dirty incorrect data. Ive therefore determined a sequence based on the cleanest source. I am using...

Hello, I am trying to come up with a formula that returns the specific ROW in a range where either Column A = "FALSE" or ISBLANK AND Column B = ISBLANK. This new formula would appear in C1. GOAL - This formula will help me determine the first row in the range that needs attention. If there...

Hi again Today's problem involves lists and ISBLANK when i am trying to remove the blank cells. 1) I have a list over 3 columns, BV, BW and BX the lists go from Row3 to Row300. I have named BV3:BX300 as tab. Some have formulae in that produce text, others have a formula that produces a blank...

Hi all, I'm sure this is a super easy problem for all you experts out there but I'm trying to figure out: On Sheet1 using an ISBLANK formula to look at cells F8,G8,H8,I8 and display whatever is written in one of them in cell C4 on Sheet2. Only one of the cells will ever have information in...

I have a formula that currently works correctly that is located in cell L2: =IFERROR(VLOOKUP(B2,'Site Assignments'!$A$1:$D$131,4,FALSE),"ASK JON FOR INFO") Now I want to add logic that says if cells F2 and I2 are blank, then leave L2 blank I think what I need to add to the formula above is the...

Hi. I'm making codes and descriptions for a list of products, the code and description is based on the product details (detailed in the following columns). Im using the CONCATENATE formula, the problem is some of the columns are not required for every item, but if I leave it blank the answer...

Hi. Is there a formula that i can use part of =IF / =IFS (the cell is not blank). As there is =IFS(ISBLANK(A1). E.g. =CONCATENATE(IFS(ISBLANK(A1),"",(the cell is not blank(A1),"YES")

I have a table of information. Let's call this Table 1. Table 1 <tbody> A B C 1 Activity TNumber ID 2 Training 54465 3 Exercise A ABC111A 91299 4 Exercise B ABC222B 91300 </tbody> This second table (let's call this Table 2) allows the user to select an Activity from a dropdown...

Hi. Could someone please help me with this, as I can't get it to work right. I need to add a message box VBA to my worksheet which forces a user to enter other data before they can enter data into a specific cell, as follows: User needs to add data on the worksheet, which fills Cell H1, in...

I have four columns of pricing data. If columns A, B, C are all blank, then I want to output whatever is in column D. If Columns A & B are blank but something is in C, then I want C. If Columns A & C are blank, but something is in B, then I want B. If Columns B & C are blank but something is...

I just got sent a spreadsheet, obviously written by someone who doesn't actually use it, with countless vlookups against huge, whole column arrays! I've shortened all those ranges down and converted to index/match which has obviously helped massively. Im thinking to change to...

*Hi all, I am trying to do some data validation against some of the fields in an input form. Basically I want to be able to do an IF error for a Vlookup to validate the currency, so if that fails it should say "INVALID", but I also would like a, if the field is blank, "PLEASE ADD ENTRY". This...

I’m looking to calculate a cell two different ways depending on whether or not it’s blank. For example: if cell B1 is blank, I want to calculate “Today()-A1”. If it is not blank, I want to calculate “B1-A1”. How would I put that into a formula that works? I can’t make it work in an IF Statement.