Auto populate details from one sheet into yearly calendar

[macydee]

Hoping someone can help my intermediate skills! I am attempting to link data from one worksheet based on date to a table calendar that encompasses the entire year. In my attachment:

On the Projects tab I want Implementation Date (Column G) to populate the data from the Project Column (Column A) on the associated date from the Calendar tab.

I am afraid because of the format of this calendar it won't work. I was thinking some type of Vlookup with IF formulas but I'm not sure how to make it import into the calendar table. I am open to other calendar types but a yearly view with dates is necessary.

[José Augusto]

Hi

Use real dates (not text) In column Projects!G:G

In your calendar use A1=2018

Use in Calendar!B3:M33 the following formula

Please Login or Register  to view this content.

See the file

[FDibbins]

Hi, welcome to the forum

When working with dates, it is almost always better to use real dates. To excel, January is just a string or letters, it is not a date, so to get the actual date, you would need something like this...
=DATEVALUE($A3&B$2&$A$1)

Then, change the format in Project, col G to Date, and re-enter the dates as real dates

You can now use that in an INDEX/MATCH, to return the data...
B3=IFERROR(INDEX(Projects!$A:$A,MATCH(DATEVALUE($A3&B$2&$A$1),Projects!$G:$G,0)),"")
copied down and across as needed

[macydee]

My saviors!!!! Thank you!

[FDibbins]

Happy to help