multiple_lookup.xlsxPlease view my attached Excel workbook.

It has 2 sheets. Sheet 1 is named "Calculator" and takes 3 fields as input: B1, B2, and B3, and then should place an answer in B4.

The data to be looked up is in Sheet 2 named "Data".

If I enter search criteria of "John", "2008", and "2" - I want B4 to tell me "High Jump" i.e. I want to get back the nameof the event which matches the event score specified for a given person and a given year.

Hope my trivial example makes sense. I've done things before with VLOOKUP and MATCH, but I can't get my head around how I would do this one.