arrays - What to use as logical function other than If in excel -

i have below set of data.

llimit  ulimit   col c  1          3       3          5       b 5         11       c 11        15       d 15        17       e 17        20       f 

in col d if enter 3.5 need result in col e "b" (corrosponding value lowerlimit , upper limit). have used if or statement, there way can using index, match or array. tried , works absolutely fine limit numbers (like 5, 11, 17, 3 etc) not working between numbers 14 (between 11 , 14). below used

{=index(f5:f10,match(1,(((d5:d10)>=h4)*((e5:e10)>=h4))*1,0))} 

was trying attach workbook, don't know how it.

use vlookup follow:

=vlookup(d2,$a$2:$c$7,3)

$a$2:$c$7 initial table llimit ulimit col c
vlookup in first column value <= d2 , return corresponding value in column 3

update
non sorted column formula needs modification:

={index($c$2:$c$7,match(1,($a$2:$a$7<=d2)*($b$2:$b$7>=d2),0),1)}    

you wrote same condition >= both limit

{=index($f$5:$f$10,match(1,((($d$5:$d$10)<=h4)*(($e$5:$e$10)>=h4))*1,0))}