Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blank Cell
I am using VLOOKUP to find and enter an associated time value in a cell (D2)
that is referencing another cell (D1). D1 generally blank until a text choice is made using a drop-down list. I would like to not have the #N/A message in D2 when D1 is blank. I could put in a generic character (such as ?) and use the IF function. However, I was wondering if there is a way determine a blank cell directly using the IF function? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blank Cell
To determine blank cell, just type two quotation marks:
=If(D1="", True, False) "quattda" wrote: I am using VLOOKUP to find and enter an associated time value in a cell (D2) that is referencing another cell (D1). D1 generally blank until a text choice is made using a drop-down list. I would like to not have the #N/A message in D2 when D1 is blank. I could put in a generic character (such as ?) and use the IF function. However, I was wondering if there is a way determine a blank cell directly using the IF function? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blank Cell
Thanks
"Anony" wrote: To determine blank cell, just type two quotation marks: =If(D1="", True, False) "quattda" wrote: I am using VLOOKUP to find and enter an associated time value in a cell (D2) that is referencing another cell (D1). D1 generally blank until a text choice is made using a drop-down list. I would like to not have the #N/A message in D2 when D1 is blank. I could put in a generic character (such as ?) and use the IF function. However, I was wondering if there is a way determine a blank cell directly using the IF function? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blank Cell
I am using VLOOKUP to find and enter an associated time value in a
cell (D2) that is referencing another cell (D1). D1 generally blank until a text choice is made using a drop-down list. I would like to not have the #N/A message in D2 when D1 is blank. I could put in a generic character (such as ?) and use the IF function. However, I was wondering if there is a way determine a blank cell directly using the IF function? If it helps, I use a UDF to return zero (or you could change this value to suit yourself) if VLOOKUP returns #N/A: Function NewVLookup(Value As Variant, Table As Variant, _ ColIndex As Integer, RangeLookup As Boolean) As Variant With Application If .IsNA(.VLookup(Value, Table, _ ColIndex, RangeLookup)) Then NewVLookup = 0 ' <========== or put your own value here Else NewVLookup = .VLookup(Value, Table, ColIndex, RangeLookup) End If End With End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste | Excel Programming | |||
Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) |