ExcelBanter - Entering and matching a value in a list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Entering and matching a value in a list (https://www.excelbanter.com/excel-discussion-misc-queries/233967-entering-matching-value-list.html)

Entering and matching a value in a list

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

Entering and matching a value in a list

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

Mr-Re Man wrote:
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

--
Message posted via http://www.officekb.com