function to return position in a list
See if this example helps:
A1:A10 contains this list:
Alpha
Bravo
Charlie
Delta
Echo
Foxtrot
Golf
Hotel
India
Juliet
B1 contains a Data Validation based on that list.
This formula returns the postition of the
selected B1 item in the source list:
C1: =IF(COUNTIF(A1:A10,B1),MATCH(B1,A1:A10,0),"")
Is that something you can work with?
Post back if you have more questions.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Bill" wrote in message
...
I'm trying to find a function(or formula) that will return the relative
position of an item selected in a list of items. For example: from a
drop-down list, if you choose the 8th item in the list, the function
returns
the value "8"; the 3rd item would return the value "3", and so on.
Any help would be greatly appreciated!
|