validations list

[PETER KAY]

Hello,

Is there a way to read the data validations list similar to a dropdown.

I need the index and the text.

Thanks in advance

Peter

 

[JE McGimpsey]

if the validation list comes from the worksheet (i.e., =A1:A5 or
=mylist), then the text will be returned in the cell (say, J1) and the
index can be obtained using

=MATCH(J1, A1:A5, FALSE)

or

=MATCH(J1, mylist, FALSE)

 

[Dave Peterson]

A lot of local community colleges offer courses in excel.

And if you want to read a book, you can find a whole list at Debra Dalgleish's
site:
http://www.contextures.com/xlbooks.html

Maybe you could print it and visit your local bookstore to see if you can find
one you like.

 

[Tom Ogilvy]

David McRitchie has some links to some tutorials:

http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials