Match Function - no room for error

D

Dee Veloper

[i apologize if this is posted twice, posting from google and got
error messages]

I'm working with an application that deals with very unstructured
data.
I'm going to use lookup functions and countiff to make sense of the
data...but there is no room for error..

if i use the function =MATCH(Selected,mylist,0) to identify the first
occurence of the text found in "Selected", can I be 100% sure that the
value returned will be the first row the value is found? For example
below if Selected=Jones I must return 1.

for example
mylist
Jones 1000 <---- must return 1 given this is first item
Jones 2000
Jones 3000
Smith 2000

is it foolproof?
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top