Entering and matching a value in a list

[Mr-Re Man]

I have a list of mobile telephone numbers in column A on "sheet2"

I want users to input on "sheet1" their mobile number and by pressing a
button alongside it, excel will check the list of mobile numbers on "sheet2"
and either respond by saying "Mobile Number Matched" or "Mobile Number Not
Matched"

Is this possible? If so, could someone post the details on how to replicate
it.

tia

 

[edvwvw via OfficeKB.com]

Try this in B1

=IF(ISNA(MATCH(A1,Sheet2!A1:A99)),"Mobile Number Not Matched","Mobile Number
Matched")

The advantage of using MATCH rather than LOOKUP is that the data does not
need to be sorted.

edvwvw