| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
| Service work order | Charts and Charting in Excel | |||
| How do I ensure dates inputted are during the work week? | Excel Worksheet Functions | |||
Linear Mode
