Does a formula exist that will lookup on ALL tabs, not just one.

J

JLS

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?
 
T

TheTraveler

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Compare numbers on 1 tab to other tabs in workbook. 1
Lookup or If, then Question 1
Hidden Tabs in a Workbook 5
Summary worksheet within a workbook 5
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0
SUMIF formula that crosses multiple sheet tabs 1
Different font sizes in different worksheet tabs 3
how do i link the names of tabs in a workbook to a summary page? 1

Top