Download Excel Start Files: http://bit.ly/2N3rHGj
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs
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).