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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks