ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Return BLANK is cell value sought is blank (https://www.excelbanter.com/excel-programming/449398-return-blank-cell-value-sought-blank.html)

frankjh19701

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


All times are GMT +1. The time now is 01:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com