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.