| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quantity Blank, Remaining cells in row appear Blank
I have a quote form in Excel. Right now, if I have a zero in the Qty column
it shows the zero, the Sku# in the next column, description in next, and so on. If I remove the zero and the part number, the remaining cells in the row show "NA"; I would like them to appear blank until the number 1 or otherwise, and the Sku# are put in the fields. This is the formula I'm using now in the description filed: =IF(B24="","",VLOOKUP(B24,List!$A$1:$C$114,2,FALSE )) -- AjaminB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| Count from Blank & Non-Blank Cells | Excel Discussion (Misc queries) | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
| Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions | |||
Threaded Mode
