| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
= If (in list)
Hi everyone,
What is the excel fuction for "in list", where cell value equals to a list of values? If A1 = "this list of values" then "1" else If A1 = "another list of values" then "2" ? end results if CA is by definition in Group 1, the function would recognize CA and return the value 1, and NY by definition in Group 2, return the value 2? States Group CA 1 NY 2 thanks! PJS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
Threaded Mode
