View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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!