• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Index

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" .
 

Attachments

p45cal

Well-Known Member
try in C6:
Code:
=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.
 
Last edited:
Top