Forum Discussion
Solved
Help with a formula for returning a value in a cell based on column heading & date
Dear Excel Community, I would appreciate your help with a problem i am trying to resolve. Please see the attached sheet for example. Date base formula So essentially i want to populate C...
- Yes, the formula uses the TODAY function which obtains the date from your computer's date.
Try this:
=INDEX($A$2:$L$10,SEQUENCE(9),XMATCH(TEXT(TODAY(),"mmm"),$A$1:$L$1))
=INDEX($A$2:$L$10,SEQUENCE(9),XMATCH(TEXT(TODAY(),"mmm"),$A$1:$L$1))
Hi Patrick,
Unfortunately that did not work. It came up with #NAME?.
When i checked the error, it said "Invalid Name Error". Assuming it didn't like something in the formula.
Unfortunately that did not work. It came up with #NAME?.
When i checked the error, it said "Invalid Name Error". Assuming it didn't like something in the formula.
- It appears you're not on 365. You may use this instead and fill down:
=INDEX($A$2:$L$10,ROW()-1,MATCH(TEXT(TODAY(),"mmm"),$A$1:$L$1,0))- Hi Patrick,
I hope you are well ? You kindly helped me with a formula for a problem i was was trying to overcome in excel.
I need to tweak the solution you provided but can't think of where to start. Are you kindly able to help again ?
Essentially, i want to modify the formula below to look back at the previous month instead of the current month. Can you advise / help ?
=INDEX($A$2:$L$10,ROW()-1,MATCH(TEXT(TODAY(),"mmm"),$A$1:$L$1,0))- Hi Raj, slight change to the formula to pull previous month:
=INDEX($A$2:$L$10,ROW()-1,MATCH(TEXT(TODAY(),"mmm"),$A$1:$L$1,0)-1)
- Fantastic Patrick, thanks for that, worked a treat.
Just to confirm, when the month changes to June, it will take data from the June column ?- Yes, the formula uses the TODAY function which obtains the date from your computer's date.