Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Create a search tool on excel for telephone number list?
hi everyone!
i need some help with excel to create a search feature
I have a spreadsheet which contains 4 columns -
A ) Surname, First name
B ) House Telephone Number
C ) Mobile Telephone Number
D ) Mobile 2 Telephone Number
I would like to create some sort of search feature which is user friendly, i need to send this document to approximately 30 senior people so they can obtain the members of staff contact details, but i dont want it to be shown as a list (over 2250 people on the list, i want it hidden) so you can only get the telephone numbers if you know the surname!
This is my idea, how can i do it? (this webpage has not allowed for extra spaces while creating my ascii drawing, but it still makes sense)....
__________________________________________________
| _______________________ |
| Surname Search - |_______________________| |
| |
| Results |
| Name - *******, **** |
| Tel 1 - **** *** **** |
| Tel 2 - *********** |
| Tel 3 - *********** |
|__________________________________________________|
3 Answers
- IXL@XLLv 71 decade agoFavorite Answer
You should really split the name into 2 columns what happens when you have staff with the same surname? A search will only find the first occurance.
Use VLOOKUP to extract data, place the list on a new sheet and define a anme for the list, then hide the sheet. Protect the workbook allowing only the search page search query to be modified.
