If cell has no value then show nothing in another cell.

[avidcat]

I am using the following formula,

=INDEX(Exceptions,MATCH($B$3,Employee_Names,0),MATCH(D36,'Accounting Exceptions'!$C$3:$IV$3,0))

But if D36 has no value at all I want to show a blank cell. Right now I am getting #N/A error.

thanks for any help.
Nick

[stanleydgromjr]

avidcat,

Try:
=IF(D36="","",INDEX(Exceptions,MATCH($B$3,Employee_Names,0),MATCH(D36,'Accounting Exceptions'!$C$3:$IV$3,0)))

[Palmetto]

But if D36 has no value at all I want to show a blank cell. Right now I am getting #N/A error.

This question in this thread stems from this originating post:
Gathering data from one sheet based on criteria from another sheet

avidcat,
I may be mistaken, but I think your problem may be that you have not converted the value in D35 (row above) to a true date value as it must be inorder find a match. Verify you have a valid date. As I mentioned in that thread, all of the cells must be converted to a true Excel date.

There is no other way, as I see it, that you can return an #N/A value ( I tested it and the look up returned a zero, which equates to a blank cell).