Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search and Display Sheet Name
What formula would I use for this process:
I'm putting this formula in cell B2 of worksheet 1. First: take the number that has been entered in cell A2 of worksheet 1 Second: Search through worksheets 3-24 and find that number (the number will be unique through out the worksheets being searched) Third: Display the name of the worksheet it was found in. I'm hoping this is possible without using VBA. If it is going to need VBA please bare with me since I have never used it. Thank You For The Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup help | Excel Discussion (Misc queries) | |||
Search within formula | Excel Worksheet Functions | |||
Display specific rows from table on other worksheet | Excel Discussion (Misc queries) |