Resuts depending on the criteria

I'm looking for a function that spits out a row given the criteria.

I have a table containing information. I want a function that when I use two specific criteria, the function will give out the results (i.e. all informaiton contain in one row).

Please see the attached spreadsheet.

Use this Array Formula in cell B14. Make sure you hold Control + Shift then press Enter to enter the formula as an array. You will see {}'s around the formula if this is done correctly.

=INDEX(B3:B7,SUM(($B$10=$C$3:$C$7)*($B$11=$F$3:$F$7)*ROW($1:$5)))

For the Date, which is F14, use this to convert the serial number to the correct date
=TEXT(INDEX(F3:F7,SUM(($B$10=$C$3:$C$7)*($B$11=$F$3:$F$7)*ROW($1:$5))),"mm/dd/yyyy")


For a larger set of data, all you need to modify is the Bold part here; Change the 5 to how many rows there are.
=INDEX(B3:B7,SUM(($B$10=$C$3:$C$7)*($B$11=$F$3:$F$7)*ROW($1:$5)))

Why not just a filter on the criteria.

See the attached file.

Try this array formula** entered in B14:

=INDEX($B3:$G7,MATCH(1,($C3:$C7=$B10)*($F3:$F7=$B11),0),COLUMNS($B14:B14))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy across to G14.

Format F14 as Date.

sorry forgot about the second criteria... use Tony's solution.