Mulitple IF and vlookup example.........so that each false contain another IF statement...you will have to continue the if statement to expand the check range
=IF(A2<=100,VLOOKUP(1,$A$6:$B$10,2,TRUE),(IF((AND(($A$2>100),($A$2<=150))),VLOOKUP(2,$A$6:$B$10,2,TRUE),FALSE)))
easiest method would...