Index and match, getting date 01/0/1900

[mmcoordes]

The referenced cell is empty

The formula is {=INDEX(=E1:E16,MATCH(D18&D20,C1:C16&B1:B16,0)))} the cell G20 is a date format, and because D6 is blank I receive 01/0/1900

I just need it BLANK

You guys are the best, thanks again in advance

[jeffreybrown]

How about just using a custom format...

0;;;@

or add an IF statement...

=IF(ISBLANK(D6),"",INDEX(E1:E16,MATCH(D18&D20,C1:C16&B1:B16,0)))

enter again as CSE

[mmcoordes]

I think, a better explanation on my part, the formula searches the desired column and cell and returns that information to cell D6 which needs to be a date. So if the formula search goes to the cell chosen by my formula and it is empty then it sends that to D6 and the I get the 01/0!1900, I've tried conditional formatting, I just tried your solution format....

[jeffreybrown]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic