"Vikram Dhemare" wrote:
It is working. But the problem is that table II does not have the whole Inv.
No. or whole part nos.
There may have some missing entries which i have to find out.
The total data of table I is about 40000 rows
& the data of table II is around 38000 rows
that means almost 2000 invoices or part nos. may have missing.

Try this slightly revised construct ..

In sheet: I

Put in E2, array-enter (press CTRL+SHIFT+ENTER):
=IF(ISNUMBER(MATCH(1,(II!$A$2:$A$38000=A2)*(II!$B$ 2:$B$38000=B2),0)),"",ROW())
Copy E2 to E40000

Then put in F2, normal ENTER:
=IF(ISERROR(SMALL($E:$E,ROW())),"",INDEX(A:A,MATCH (SMALL($E:$E,ROW()),$E:$E,0)))
Copy F2 to G2, fill down until blanks appear,
signalling exhaustion of data extract
[since the discrepancy is around 2000 missing rows,
fill down to say, G2010 (say), to cover the expected extent]

Cols F and G would return all the invoice-part nos in I which are missing in
II,
with all results neatly bunched at the top
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---