forumal does not work

G

Guest

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
 
Top