Hi,
I have the following formula which works well for my purposes:
{=IFNA(INDEX('Sbj vis summ3'!$M$2:$M$10000,MATCH(1,($B3='Sbj vis summ3'!$E$2:$E$10000)*($C$2='Sbj vis summ3'!$L$2:$L$10000),0)),"not found")}
How can I update it so that it returns a date for all meaningful matches; in other words, how do I embed the DATEVALUE operator in there? Currently meaningful finds are returned as in the image below, even after I format cells to "date".
I have the following formula which works well for my purposes:
{=IFNA(INDEX('Sbj vis summ3'!$M$2:$M$10000,MATCH(1,($B3='Sbj vis summ3'!$E$2:$E$10000)*($C$2='Sbj vis summ3'!$L$2:$L$10000),0)),"not found")}
How can I update it so that it returns a date for all meaningful matches; in other words, how do I embed the DATEVALUE operator in there? Currently meaningful finds are returned as in the image below, even after I format cells to "date".
Attachments
Last edited: