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

Описание: Download Excel Start Files: https://excelisfun.net/files/EMT1538-...
Entire page with all Excel Files for All Videos: https://excelisfun.net/files/

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).