• 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


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



Well-Known Member
try in C6:
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: