| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can you write a formula that searches for a particular word?
I have approximately 30 worksheets in one workbook. I have one worksheet
called, "Search Template" where I want to be able to type in a word in a particular cell (say, D6) and have Excel look through all the other worksheets in the workbook and pull back the information about that word. For example, if I type in the word LOAN on the "Search Template" worksheet in cell D6, I want Excel to find the word LOAN in the other worksheets and pull back the entire row(s) of information where that word, LOAN is found. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW PUT WORD-ART IN THE BACKGROUND AND WRITE OVER IT | Excel Worksheet Functions | |||
| Getting valid web searches and avoiding sites that contaminate web searches | New Users to Excel | |||
| FIND formula that searches from right? | Excel Worksheet Functions | |||
| which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
| which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
Threaded Mode
