Forum Discussion
Excel Vlookup / Index-Match Not Working
Riny_van_Eekelen Thanks Riny, Yes this is a very basic sheet however I am trying to understand the concept and what i am doing wrong here. I have attached the file, thank you for the help.
Gatertech This particular template (I found it in the Excel start-up page) is nothing more than something that produces a month view, where you can then type in whatever is happening on a certain day and perhaps print it as a reference document. The date fields in the calendar are in fact date values where the due dates on your Sheet1 are just numbers. I adopted the calendar template for you and inserted VLOOKUP formulae that display the Description and Amount for that particular day. However, it will not work if you enter multiple items on the same day.
Having said that, a calendar template is NOT suitable to control a budget. You can find other templates to do a better job. But, you must stick to whatever the template dictates as they are often very difficult to customise. Up to you to decide though.