Using VLOOKUP or INDEX/MATCH

I am struggling a little bit with EXCEL. I have a few reports that are on separate sheets in one Workbook. On a summary sheet, I am trying to reference a cell that contains a date in it. Then I am trying to match that date with the same date in a range of cells on another sheet. Then after I find that cell on that sheet I want to reference the column next to it. PLEASE HELP! I hope this makes sense.

How to attach a sample workbook:

1. Below the "Quick Reply" thread frame, click the "Go Advanced" button.
2. On the edit toolbar, click the "Attachments" button.
3. In the "File Upload Manager" window, click the "Add Files" button.
4. In the "Upload Files from your Computer" window, click the "Select Files" button.
5. In the Windows Explorer window, locate and select your workbook, then click the "Open" button.
6. In the "Upload Files from your Computer" window, click the "Upload Files" button.
7. In the "File Upload Manager" window, click the "Done" button (lower right of screen).