If you're talking about the MATCH function, you can use this.

=MATCH(1,--EXACT(A1:A100,"SAND"),0)
This is an array function and as such, you'll need to hold CTRL and SHIFT before pressing ENTER