iserror and vlookup with multiple criteria from multiple tables along with concatenation.

Hello Group.

I have the following delima, I keep getting lost in my formula. basically a bunch of if statements with iserror and vlookup.

Scenario
I have 3 Data Tables
Each Table has a date and name field.
I have a calendar heading that basically needs to pull the data from those 3 data tables for the specific date(s) on the calendar, and either just display the name of a specific date that may be in the data table, or concatenate the names separated by a /.
Table Names are as follows: Holidays, EventDates, BirthDays
Here is what I currently have for a formula but so far I've lost myself and am getting an error during testing.

Please Login or Register  to view this content.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

I rewrote the formula from scratch, and ended with C3:

Formula:

Please Login or Register  to view this content.

it concatenates eventname proceeded by " / " from all calendars (if no match is found empty string is used for concatenation).
so result of concatenated 3 iferrors can be in one of 4 forms:
/ event / event / event
/ event / event
/ event
(empty)
always taking MID from 4th character (in case of empty string it anyway returns empty) gives us a good result.
I do not expect calendar values to be longer than 330 chars, so used 1000 as third parameter for MID function.

Test it!