Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does a formula exist that will lookup on ALL tabs, not just one.
I need to lookup a number from one workbook to another, however, I want to
look up the value in ALL 800 tabs, not just the first tab. Is there a formula that will allow me to look up the value in any tabs within a workbook? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does a formula exist that will lookup on ALL tabs, not just one.
No...
-- HTH... Jim Thomlinson "JLS" wrote: I need to lookup a number from one workbook to another, however, I want to look up the value in ALL 800 tabs, not just the first tab. Is there a formula that will allow me to look up the value in any tabs within a workbook? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does a formula exist that will lookup on ALL tabs, not just on
I may be showing my ignorance here, but can't you select all the tabs and
then use CTRL F? I don't have 800 tabs, but I do this often. I am also looking for specific values or text, not formulas. -- TheTraveler "Jim Thomlinson" wrote: No... -- HTH... Jim Thomlinson "JLS" wrote: I need to lookup a number from one workbook to another, however, I want to look up the value in ALL 800 tabs, not just the first tab. Is there a formula that will allow me to look up the value in any tabs within a workbook? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does a formula exist that will lookup on ALL tabs, not just one.
No.
800 sheets in a workbook!!! Gord Dibben MS Excel MVP On Fri, 9 Apr 2010 12:45:01 -0700, JLS wrote: I need to lookup a number from one workbook to another, however, I want to look up the value in ALL 800 tabs, not just the first tab. Is there a formula that will allow me to look up the value in any tabs within a workbook? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does a formula exist that will lookup on ALL tabs, not just on
That would be "finding" not "looking up" in the sense that OP may be
referring to VLOOKUP or INDEX/MATCH or similar function. In your case of "finding" you don't need to select all the sheets. Just set Find options to Within: workbook. Gord Dibben MS Excel MVP On Fri, 9 Apr 2010 15:19:02 -0700, TheTraveler wrote: I may be showing my ignorance here, but can't you select all the tabs and then use CTRL F? I don't have 800 tabs, but I do this often. I am also looking for specific values or text, not formulas. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does a formula exist that will lookup on ALL tabs, not just on
Time to think ... Access ??
"Gord Dibben" wrote: No. 800 sheets in a workbook!!! Gord Dibben MS Excel MVP On Fri, 9 Apr 2010 12:45:01 -0700, JLS wrote: I need to lookup a number from one workbook to another, however, I want to look up the value in ALL 800 tabs, not just the first tab. Is there a formula that will allow me to look up the value in any tabs within a workbook? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMDIVISION formula function - does it exist? | Excel Worksheet Functions | |||
SUMDIVISION Formula - does it exist? | Excel Discussion (Misc queries) | |||
V lookup in separate TABS! | Excel Discussion (Misc queries) | |||
why exist a formula for excel and another for vba? pmt, payment | Excel Discussion (Misc queries) | |||
Getting #N/A from Vlookup when matching value exist in the lookup data range. | Excel Worksheet Functions |