Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?!

Download Excel Start Files:
Entire page with all Excel Files for All Videos:

In this video learn how to lookup numbers on either side of a hurdle. Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?!
Original question:
I have 3, 6, 7, 13, 15, 18, 19 in a column and I want the first number greater and less than 11. (I want 7 in a cell and 13 in a different cell).

Excel,Highline College,Mike Girvin,excelisfun,Excel Magic Trick,EMT,EMT 1542,Excel Magic Trick 1542,Array Formulas,LOOKUP Function,MATCH Function,INDEX Function,Approximate Match,Exact Match,Lookup Two Numbers on Either Side of a Hurdle,Lookup First Numbers Greater Than Hurdle & Less Than Hurdle,Get First Number,Get Last Number,Lookup Last Number,Look First Number,