=MATCH("D",A2:A7,0)

zangief wrote:
I need to return the position of a cell in a list. For example, I have
the list:

A
B
C
D
E
F

I need a funciton that will tell me if D is the first cell, second,
third, etc...

Thanks.



--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.