index match function

%3CLINGO-SUB%20id%3D%22lingo-sub-1109526%22%20slang%3D%22en-US%22%3Eindex%20match%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1109526%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%2C%3C%2FP%3E%3CP%3Ehelp%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20want%20to%20update%20date%20daily%20according%20to%20%3CFONT%20face%3D%22arial%20black%2Cavant%20garde%22%3Etodays%20date%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22arial%20black%2Cavant%20garde%22%3Eor%20get%20date%20from%20a%20reference%20cell%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22andale%20mono%2Ctimes%22%3Ehow%20can%20i%20do%20it%20%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DINDEX('%5BPRESCREENING%20JANUARY-2020.xlsx%5D%3CFONT%20face%3D%22arial%20black%2Cavant%20garde%22%3E14-01-2020%3C%2FFONT%3E'!K%3AK%2CMATCH(%24N%247%2C'%5BPRESCREENING%20JANUARY-2020.xlsx%5D14-01-2020'!A%3AA%2C0))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehelp%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1109526%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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