View Single Post
  #2   Report Post  
Old May 16th 05, 06:32 PM
Posts: n/a

Why don't you try MATCH instead?

=MATCH(A2,A3:A20,0) will give you the row, relative to the range. For
example, if the value in A2 is in A5, the MATCH function will return 2-5=3.

Hope this helps and if it does please vote for this post.

"Spock" wrote:

I'm trying to obtain the address of a cell using the Cell Function and the
Vlookup function. i.e. =Cell("address",vlookup(A2,A320,4,False)) However, I
get an error when I execute the function. Any suggestions?