Example of the formula to check the first of 30 tabs of data.
=IF(ISNA(VLOOKUP($C2,[Book2.xls]Sheet1!$H:$H,1,FALSE)),0,1)
[Book2.xls] should be changed to the 'different spreadsheet'
Sheet1 should be changed to the name of the first of the 30 tabs of data

=IF(ISNA(VLOOKUP($C2,[Book2.xls]Sheet2!$H:$H,1,FALSE)),0,1)
Sheet2 should be changed to the name of the second of the 30 tabs of data

etc., etc., etc.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"chelldog" wrote:

Thank you....so, what would the formula look like if the part#'s from my
first file were in column C and the part# field on the second file was in
column H on each tab?

"Gary L Brown" wrote:

30 vlookups that you then copy down 650 rows?
=if(isna(VLOOKUP(A2,'[MyFile.xls]MySheet1'!$A:$D,4,FALSE)),0,1)
=if(isna(VLOOKUP(A2,'[MyFile.xls]MySheet2'!$A:$D,4,FALSE)),0,1)
...
=if(isna(VLOOKUP(A2,'[MyFile.xls]MySheet30'!$A:$D,4,FALSE)),0,1)
etc.
Using something like the example formula above where if it finds the item it
will put a -1- in the cell, if it doesn't, it will put a -0- in the cell, in
the 31st column, put a =sum(C:AH) [or whatever the columns are]. Check that
column. If you see something other than -0-, you've got a match.
HTH,
--
Gary Brown

"chelldog" wrote:

I have a spreadsheet that contains hundreds and hundreds of part#'s. My
project is to determine whether or not these part#'s are in a different
spreadsheet that has 30 different tabs of data. Is there is an easier way of
doing this other then manual queries?