forumal does not work
 

Dear
A table as below.

Column 1
BOX 1 Column 2
1-4 15
5-9 16
10 or above 17

BOX 2
Colurm 3 Column 4
1-2 10
3-4 12
5-7 14
8 or above 16



Box 1 = =VLOOKUP(IF(E85<=4.99,"1-4",IF(E85=5,IF(E85=10,"10 or
above","5-9"))),$C$99:$D$101,2,0)

Box 2 = VLOOKUP(IF(E85<=2.99,"1-2",IF(E85=3,IF(E85=5, "5-7",IF(E85=8,"8
or above","3-4")))),$C$104:$D$107,2,0)


* I am not show all data with security isseus.

Thanks
111.COM