| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search Box
I am making a small dictionary in Excel 2003 and will like to know if someone
knows how I can insert a search box to find a word of the dictionary. Thnaks a lot!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search Box
I'm not sure what you mean by 'Find' do you mean that or do you mean go to.
Here' one way. With your words in column A and and their definitions in column B and the word you are looking for in C1 try this formula:- =VLOOKUP(C1,A:B,2,FALSE) Mike "Tmms" wrote: I am making a small dictionary in Excel 2003 and will like to know if someone knows how I can insert a search box to find a word of the dictionary. Thnaks a lot!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Setting up and Configuration of Excel | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Links and Linking in Excel | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Hybrid Mode
