Concatenate/VLOOKUP

[Jerche12]

Hi There

I'm a relatively new user to Excel and I've been trying to create a calendar that autopopulates based on values in a different workbook. Unfortunately I've hit a roadblock when I try to draw strings/phrases from two different columns based on the same criteria. Right now I'm using the following formula:

Workbook: Calendar, Cell B8
=CONCATENATE(IFERROR(VLOOKUP(B7,Dates!$C:$F,2,0),0),IFERROR(VLOOKUP(B7,Dates!$C:$F,4,0),0))

I'm trying to look to see if cell B7, matches any of the date cells in the Dates workbook, and then if it does to return the corresponding description. If it matches more than one cell, then I'd like for it to return both of the corresponding cells. For instance I'd like the formula to search for the 09/08/2014 string and return both "Linda Start" and "Jerry End". Ive spent forever looking through the forum and I just can't seem to get my formula right. Thank you guys so much for your help and sorry for what I'm sure is a relatively simple answer.

Thanks!
Jerry