Need help with a vlookup formula; trying to capture more than one item

[jooka84]

Hello.
I'm working on a calendar in excel which auto populates from a sheet in the same file.

Currently this is the formula that is being used - =IF(ISERROR(VLOOKUP(C11,Dates!$C:$D,2,FALSE)),"",VLOOKUP(C11,Dates!$C:$D,2,FALSE))

I've attached the file. As you'll see on January 1 I have 2 events that need to show up in the calendar but it's only pulling the first item. How do I fix it so that both items are being pulled into the calendar?Calendar 040914.xlsx

[Pete_UK]

Take a look at my attachment in Post #2 of this thread:

http://www.excelforum.com/excel-gene...-switcher.html

It seems to be very similar to what you are trying to do.

Hope this helps.

Pete

[jooka84]

This looks like what I'm looking for. I will test it out. Thank you Pete!

[jooka84]

Hi Pete. Thank you again. I do have one question. How do I change the drop down menu for the month to show the actual name of the month instead of the number?

Jill