Index / Match on possible blank Date fields

[fddekker]

I am using the following syntax to find a possible date or blank:

=INDEX(Invoices!$B$2:$B$192,MATCH(E2,Invoices!$A$2:$A$192,0))

Since the column were the result is displayed should be in date format, empty finds are displayed as 1/0/1900.

I know that I can use the test:
IF (result = blank, "", "lookup-result"), but in this case I have to type the whole Index/Match formula twice, which just don't look like very good coding.

I've tried ISBLANK, without the desired result.

What is the best way to test if the look-up result is blank, and then keep the result field also blank?

Thanks in advance.

 

[Aladin Akyurek]

Try to describe a problem you want to solve in words (concisely) along with a scaled-down sample. The problem description by means of a non-working formula is often not the right thing to do. Guessing:

Control+shift+enter, not just enter:

=IFERROR(INDEX(Invoices!$B$2:$B$192,MATCH(1,IF(1-(Invoices!$B$2:$B$192=""),IF(Invoices!$A$2:$A$192=E2,1)),0)),"")