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