Forum Discussion

eliusk1's avatar
eliusk1
Copper Contributor
Jan 15, 2020

index match function

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 

No RepliesBe the first to reply

Resources