| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Return BLANK is cell value sought is blank
I have a INDEX and MATCH formula set to look for certain values in one sheet and return the data from adjacent cells. But, if the cell the formula refers to is blank, it returns a "0" instead of just leaving the cell blank. Does anyone know how I can change my formula:
=INDEX('Sheet1'!D$2:D$192, MATCH(A29,'Sheet1'!C$2:C$178,0)) to return a "BLANK" ?? Any and all assistance will be greatly appreciated. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return blank cell if data cell is blank | Excel Worksheet Functions | |||
| Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
| How to return a blank formula cell if the reference 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 | |||
| If cell blank return a blank | Excel Worksheet Functions | |||
Linear Mode
