Yes, you could put in B2. Or any other open cell.

HTH
Jason
Atlanta, GA

-----Original Message-----
The second formula with index, would that be placed in
B2?

"Jason Morin" wrote:

Searching an entire sheet is requires some serious
processing power and probably isn't necessary. Let's
assume that you want to examine A1:A100 on each sheet.

1. List the sheet names to search down col. A,
starting
in A5.

2. Put this formula in B5 and copy down:

=SUMPRODUCT(--EXACT(INDIRECT("'"&A5&"'!A1:A100"),$A$2))

3. Now use this to pull in the Sheet name with the
value:

=INDEX(A5:A26,MATCH(1,B5:B26,0))

HTH
Jason
Atlanta, GA


-----Original Message-----
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!

.


.