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