VlookUp duplicate values differents sheets

[Goalexcel]

Hello Experts, please kindly help to find a formula, lookup in sheet Assignment column A need to copy to sheet Month View (Calendar) in each day.
For example for jun1 have 3 assignments need to copy in month view en the calendar on jun 1 the 3 assignments only.. Thank you for your attention.

 

[Saba Sabaratnam]

Hi

Enter the following formula in C1 and copy it down

=ROW()

Enter the array formula in I3 and copy it down and then across by pressing Shirt + Control + Enter

=IFERROR(INDEX(IF(I$1=$B$1:$B$8,$A$1:$A$8,"na"),SMALL(IF(I$1=$B$1:$B$8,$C$1:$C$8,"na"),$H2)),"")

Kind regards

Saba

 

[Goalexcel]

Hi

Enter the following formula in C1 and copy it down

=ROW()

Enter the array formula in I3 and copy it down and then across by pressing Shirt + Control + Enter

=IFERROR(INDEX(IF(I$1=$B$1:$B$8,$A$1:$A$8,"na"),SMALL(IF(I$1=$B$1:$B$8,$C$1:$C$8,"na"),$H2)),"")




View attachment 40361

Kind regards

Saba

Thank you for your replay Saba, I tried to apply the formula, but I notice we are working in different format. I am sending to you the original Excel file, please open the link below.

Transfer - Dropbox

Dropbox is a free service that lets you bring your photos, docs, and videos anywhere and share them easily. Never email yourself a file again!

www.dropbox.com

 

[BigDawg15]

Goalexcel,

Using Saba's formula, I believe this is what you were looking for.

Dropbox - File Deleted - Simplify your life

www.dropbox.com

Regards,

BigDawg15

 

[Goalexcel]

Goalexcel,

Using Saba's formula, I believe this is what you were looking for.

Dropbox - File Deleted - Simplify your life

www.dropbox.com

Regards,

BigDawg15

Thank you so much for your replay.
I found this post Trying to make excel generate a dynamic calendar grid based off a list of events

Please I need to add a code that can column K containing task copy in each row of the calendar. At the moment, you can see column K task is copied all in one row in the calendar for each day.

Here is the Magic Calendar

Transfer - Dropbox

Dropbox is a free service that lets you bring your photos, docs, and videos anywhere and share them easily. Never email yourself a file again!

www.dropbox.com

 

[BigDawg15]

You only need to change the start date on the Month View worksheet in cell B8. The rest should fill in. I'm not sure
how to change it using the month dropdown.

Dropbox - File Deleted - Simplify your life

www.dropbox.com

BigDawg15

 

[BigDawg15]

Goalexcel,

I was able to modify previous file a bit. Only need to change month number in cell D1.

Dropbox - File Deleted - Simplify your life

www.dropbox.com

I hope this will work for you,

BigDawg15