View Single Post
  #6   Report Post  
Louise
 
Posts: n/a
Default




Did you download the file from the web site?

Alan Beban



Yes, Alan, I did. I think the the greater difficulty is the difference in
the names of the functions in english and spanish. Finaly I used a formula
like this:

=MATCH("pine",A1:A100,0)

I made modifications.
In spanish is like this: =COINCIDIR($A141;B$1:B$130;0)

This solution was written by Jerry W. Lewis in microsoft.public.excel,
simple, but works well.


Thanks to you, Jason and Alan for your interest about this question.