vendredi 7 avril 2017

What to use as logical function other than If in excel

I have below set of data.

LLimit  ULimit   Col C 
1          3       a
3          5       b
5         11       c
11        15       d
15        17       e
17        20       f

in col D if i enter 3.5 i need result in col E as "b" (corrosponding value to lowerlimit and upper limit). I have used If or statement, However is there a way i can do this using Index, Match or array. I tried and it works absolutely fine with the limit numbers (like 5, 11, 17, 3 etc) but not working with between numbers like 14 (between 11 and 14). Below is what i used

{=INDEX(F5:F10,MATCH(1,(((D5:D10)>=H4)*((E5:E10)>=H4))*1,0))}

Was trying to attach workbook, but don't know how to do it.

Aucun commentaire:

Enregistrer un commentaire