Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search / find Formula
Hi,
what is the formular that i can use to take one cell with data in it and shearch/find that exact data throughout my workbook? The data will be entered differently each time. It is exactly like the 'find function' in your edit tab. but i want to put it in my opening sheet. thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search / find Formula
Not quite sure what you're wanting. Do you want the find dialogue box to
appear, or do you want a formula that will search for a word in another cell? Former: Just press Ctrl+F Latter: Probably want to use either the SEARCH, FIND, or MATCH function, depending on what area you are searching. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Michael" wrote: Hi, what is the formular that i can use to take one cell with data in it and shearch/find that exact data throughout my workbook? The data will be entered differently each time. It is exactly like the 'find function' in your edit tab. but i want to put it in my opening sheet. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF with Search/Find??? | Excel Worksheet Functions | |||
Couldnt find in search | Excel Discussion (Misc queries) | |||
Cells.Find , why it DOESN'T search ? help | New Users to Excel | |||
Help with a formula for concatenate and search/find with 3 columns | Excel Worksheet Functions | |||
Can Search find 2 or more "/"? | Excel Discussion (Misc queries) |