Excel formula to get MAX from just a part of data

Hello


I'm having a problem with getting the right formula in excel 2010. I've got a table with few columns, but i'm only going to use data for 2 of them. In one of them, i've got NAMES, in another - DATES (in a format of YYYYMMDD). In another sheet i use a field, where i put the NAME, and i want to get the last (most recent) date for that name (so, as it's a number, i can just get the MAX out of it). The number of the name occurance varies, sometimes it's none (where it'll show that there's none, but that's a simple function), sometimes it can get to couple dozens.

I know, how to make it in SQL, more or less. It'd be something like:
SELECT MAX(date_column) FROM table WHERE NAME = C5;
C5 being the field, where i put the NAME for search.

I don't know why, but i get the error, when trying to upload a file, so here's a sample table. I want a formula, that when i type "mary" in a "search cell", i get the response 20141126, when i type "Zoe", I get 20141119, when i type TED, (he's not in the table), then i get a blank cell/null/something like that.

Name(Column A)	Date(Column B)
Mary	20141120
Mary	20141126
John	20141101
John	20141105
John	20141115
Steve	20141116
Zoe	20141109
Zoe	20141110
Zoe	20141113
Zoe	20141119

Hi, to attach your workbook, click "Go Advanced" button and then find Paperclip Button to attah the file.

Thanks