| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank Cell
using the following formula in sheet 1 Cell K80 (formatted as Date);
=IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE)) How do I change the formula to have cell K80 blank and not a zero if their is no data in Data range column 20. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank Cell
=IF(OR(ISBLANK(A60),VLOOKUP(A60,Data,20,FALSE)=0), "",VLOOKUP(A60,Data,20,FALSE))
-- Regards Dave Hawley www.ozgrid.com "Missile" wrote in message ... using the following formula in sheet 1 Cell K80 (formatted as Date); =IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE)) How do I change the formula to have cell K80 blank and not a zero if their is no data in Data range column 20. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank Cell
Try
=IF(A60<"", IF(ISNA(VLOOKUP(A60,data,20,0)),"", IF(VLOOKUP(A60,data,20,0),VLOOKUP(A60,data,20,0)," ")),"") -- Jacob "Missile" wrote: using the following formula in sheet 1 Cell K80 (formatted as Date); =IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE)) How do I change the formula to have cell K80 blank and not a zero if their is no data in Data range column 20. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank Cell
Thanks Dave, that worked for that cell, but when I applied it to all other
cells required in Sheet 1 Column K I now get a #N/A error where the corrosponding cell in Column A is blank, with original formula I did not get that error. Any suggestions ? Thanks again "ozgrid.com" wrote: =IF(OR(ISBLANK(A60),VLOOKUP(A60,Data,20,FALSE)=0), "",VLOOKUP(A60,Data,20,FALSE)) -- Regards Dave Hawley www.ozgrid.com "Missile" wrote in message ... using the following formula in sheet 1 Cell K80 (formatted as Date); =IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE)) How do I change the formula to have cell K80 blank and not a zero if their is no data in Data range column 20. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank Cell
Excellent, works great.
Thanks "Jacob Skaria" wrote: Try =IF(A60<"", IF(ISNA(VLOOKUP(A60,data,20,0)),"", IF(VLOOKUP(A60,data,20,0),VLOOKUP(A60,data,20,0)," ")),"") -- Jacob "Missile" wrote: using the following formula in sheet 1 Cell K80 (formatted as Date); =IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE)) How do I change the formula to have cell K80 blank and not a zero if their is no data in Data range column 20. Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank Cell
I wouldn't use the double VLOOKUP method with ISNA. See page below for
betters ways. http://www.ozgrid.com/Excel/stop-na-vlookup.htm -- Regards Dave Hawley www.ozgrid.com "Missile" wrote in message ... Thanks Dave, that worked for that cell, but when I applied it to all other cells required in Sheet 1 Column K I now get a #N/A error where the corrosponding cell in Column A is blank, with original formula I did not get that error. Any suggestions ? Thanks again "ozgrid.com" wrote: =IF(OR(ISBLANK(A60),VLOOKUP(A60,Data,20,FALSE)=0), "",VLOOKUP(A60,Data,20,FALSE)) -- Regards Dave Hawley www.ozgrid.com "Missile" wrote in message ... using the following formula in sheet 1 Cell K80 (formatted as Date); =IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE)) How do I change the formula to have cell K80 blank and not a zero if their is no data in Data range column 20. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Linear Mode
