D8=VLOOKUP(MAX(IF($E$2:$E$5<=C8,$E$2:$E$5,"/")),$E$2:$G$5,3,) Press Shift,Control and Enter to run