GrahamCracker19
New Member
- Joined
- Nov 4, 2015
- Messages
- 13
I'm trying to put together a formula that will find if a value in one table is a date to return that date otherwise return a blank cell. I want to use an index/match formula for my key data as the rows on the two tables will not necessarily be the same.
This is the formula that I tried
IF(INDEX('Sheet 1'!H:H,MATCH([@SOI2],'Sheet 1'!F:F,0))<>"",ISNUMBER(DATEVALUE([@[Ship Date 4/20]])))
The value that returns whether or not the cell is blank or a date is "FALSE"
This is the formula that I tried
IF(INDEX('Sheet 1'!H:H,MATCH([@SOI2],'Sheet 1'!F:F,0))<>"",ISNUMBER(DATEVALUE([@[Ship Date 4/20]])))
The value that returns whether or not the cell is blank or a date is "FALSE"