Forum Discussion
Excel Vlookup / Index-Match Not Working
Gatertech I believe I recognise the template and you are trying to use this very basic (and quite useless) one to do something it isn't built to do. Not that you can't amend it, but it will not be very easy in most cases. Difficult to give recommendations on the basis of screenshots. Can you upload your file? Just delete anything private and confidential but leave the basic information from Sheet1 in there.
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.
