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