Thanks, but I'm still having some troubles with this. The name of my first
workbook is, 3100. The name of my second work book is RA Recreates 2008. The
second workbook is the one with over 300 worksheets in it. Each worksheet is
a date, ex( 1-2, 1-3, 1-4 and so on). In the First workbook named 3100 I only
have one worksheet with one column of information. In the column it has
Barcode number not the barcode font, ex( Reeejkjkjkeio) it's 12 digits. What
I'm trying to do is in Column 2 of the worksheet I'm wanting to look through
all the worksheets of the other workbook to find if the barcode in A1 is in
it. If so return a 'Yes' if not return a 'No'. I hope the more details can
get us to the solution.

"Héctor Miguel" wrote:

hi, !

Thank you so much but I've only got one question, I'm good in Excel but I've never dealt with Array's.
Could you point me in the right direction to build this array that your talking about below?

let's say you put the name of your other workbook (i.e.)
[A1] - "first workbook.xls" (no quotes) and the ~300 sheet names en [A2:A301]
with the bar-code to seek in [B1]

[C1] =if(sumproduct(countif(indirect("'["&a1&"]"&a2:a301&"'!a:a"),b1)),"yes","no")

*IF* all of your ~300 sheet names shares a pattern (shet1, sheet2...sheet300)
you could by-pass the a2:a301 range and build an array (but I don't know the sheets names)

hth,
hector.

__ previous __
you could have/build an horizontal array for your ~300 worksheet names (in the first workbook)
and then use a formula like the following (note that first workbook shall be open):

[B1] =if(sumproduct(countif(indirect("'first workbook.xls"&{"array";"of";"sheet";"names"}&"'!a: a"),a1)),"yes","no")

__ OP __
I've got two workbooks, one has over 300 worksheets in it and one only has two worksheets.
In the workbook that has two worksheets I've got two columns A1 has a bar codes in in from A1 through A3100.
Column two is empty. I'm trying to uses an equation in B1 that will do the following but in and equation form.
Look into Workbook one and if any cell has the barcode that is in A1 than state a Yes if not state a No.
I can do it for a worksheet but I'm trying it for the entire workbook. This will cut having to do it over 300 different times.