finding a value in a list

[Gixxer_J_97]

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)?

[Tom Ogilvy]

=match(cell with validation, validation range/list,0)

--
Regards,
Tom Ogilvy

"Gixxer_J_97" <[email protected]> wrote in message
news:[email protected]...
> 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)?
>
>

[Gixxer_J_97]

thanks Tom!

J

"Tom Ogilvy" wrote:

> =match(cell with validation, validation range/list,0)
>
> --
> Regards,
> Tom Ogilvy
>
> "Gixxer_J_97" <[email protected]> wrote in message
> news:[email protected]...
> > 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)?
> >
> >
>
>
>