Dynamic Index

[Raghava@rock]

Hi Team,

I am looking for a way were we can make the Index dynamic , i mean based on the date in the attached file in the Sheet1 on Cell C5 the Index should change to respective column in Sheet2 .

For Example if date in Sheet1 Cell C5 is 3/13/2020 then the Index formula should be changed to column "I" .

 

[p45cal]

try in C6:

=IF(ISNA(MATCH($B6,INDEX(Sheet2!$C$5:$M$23,0,MATCH(C$5,Sheet2!$C$5:$M$5,0)),0)),"NEW",$B6)

You might have to enter this formula using Ctrl+Shift+Enter rather than the usual plain Enter depending on your version of Excel.

 

[Raghava@rock]

Thank you That worked perfect.