index match function

Occasional Visitor

Dear all,,

help

 

i want to update date daily according to todays date

or get date from a reference cell

 

how can i do it ?

 

 

=INDEX('[PRESCREENING JANUARY-2020.xlsx]14-01-2020'!K:K,MATCH($N$7,'[PRESCREENING JANUARY-2020.xlsx]14-01-2020'!A:A,0))

 

help 

0 Replies