Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding a value in a list
if you have a named list, say 'Names'
and that list is used as the source for a data validation cell, is there a way to find what position the selected value is at in the list? ie if Names contains: Frank Bob Joe Tim and I have selected 'Joe' in my cell, how do i find that 'Joe' is index # 3 (if it starts from 1, or index #2 if it starts from 0)? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding a value in a list
=match(cell with validation, validation range/list,0)
-- Regards, Tom Ogilvy "Gixxer_J_97" wrote in message ... if you have a named list, say 'Names' and that list is used as the source for a data validation cell, is there a way to find what position the selected value is at in the list? ie if Names contains: Frank Bob Joe Tim and I have selected 'Joe' in my cell, how do i find that 'Joe' is index # 3 (if it starts from 1, or index #2 if it starts from 0)? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding a value in a list
thanks Tom!
J "Tom Ogilvy" wrote: =match(cell with validation, validation range/list,0) -- Regards, Tom Ogilvy "Gixxer_J_97" wrote in message ... if you have a named list, say 'Names' and that list is used as the source for a data validation cell, is there a way to find what position the selected value is at in the list? ie if Names contains: Frank Bob Joe Tim and I have selected 'Joe' in my cell, how do i find that 'Joe' is index # 3 (if it starts from 1, or index #2 if it starts from 0)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding out whether text is in a list or not | Excel Worksheet Functions | |||
Finding out whether text is in a list or not | Excel Worksheet Functions | |||
Finding a sum in a list of values | Excel Discussion (Misc queries) | |||
Finding new entries in list | Excel Programming | |||
Finding Blanks in list | Excel Programming |