| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering matching data for line charts | Charts and Charting in Excel | |||
| Matching items in 2 list to consolidate to one list | Excel Discussion (Misc queries) | |||
| entering data from a list | Excel Worksheet Functions | |||
| Workbook for entering POs and matching and paying invoices | Excel Discussion (Misc queries) | |||
| Entering from List box | Excel Worksheet Functions | |||
Linear Mode
