I have data in this format:

Sheet #1
Name Year Amount
Joe 2000 100
Joe 2005 200
Sam 2003 65

And want to return Amount in another worksheet.

Sheet#2
2000 2003 2005
Joe
Sam

How do I do the lookup or match to get the data for Joe for 2000 and 2005 in
the proper cells of Worksheet#2