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?