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?