Please any 1 help me to find out the solution as listed below

''''''''''''please help me to find the result as shown as folliows
'Sheet1
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7
a1 b1 c1
a2 b2 c2
a3 b3 c3
a4 b4 c4
a5 b5 c5
a6 b6 c6
a7 b7 c7
a8 b8 c8
a9 b9 c9
a10 b10 c10
a11 b11 c11
a12 b12 c12
a13 b13 c13
a14 b14 c14
a15 b15 c15
a16 b16 c16
a17 b17 c17

'Sheet2
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7
a1 b1 c1
a2 b2 c2 d2
a3 b3 c3
a4 b4 c4
a5 b5 c5
a6 b6 c6 d6
a7 b7 c7
a8 b8 c8
a9 b9 c9
a10 b10 c10
a11 b11 c11 d11
a12 b12 c12
a13 b13 c13
a14 b14 c14
a15 b15 c15
a16 b16 c16
a17 b17 c17 d17

'Sheet3
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7
a1 b1 c1 d1 e1
a2 b2 c2 e2
a3 b3 c3 d3 e3
a4 b4 c4
a5 b5 c5 d5
a6 b6 c6 e6
a7 b7 c7 d7 e7
a8 b8 c8
a9 b9 c9
a10 b10 c10 d10 e10
a11 b11 c11
a12 b12 c12 d12
a13 b13 c13 d13 e13
a14 b14 c14
a15 b15 c15
a16 b16 c16 d16 e16
a17 b17 c17



'RESULT_SHEET
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7
a1 b1 c1 d1 e1
a2 b2 c2 d2 e2
a3 b3 c3 d3 e3
a4 b4 c4
a5 b5 c5 d5
a6 b6 c6 d6 e6
a7 b7 c7 d7 e7
a8 b8 c8
a9 b9 c9
a10 b10 c10 d10 e10
a11 b11 c11 d11
a12 b12 c12 d12
a13 b13 c13 d13 e13
a14 b14 c14
a15 b15 c15
a16 b16 c16 d16 e16
a17 b17 c17 d17














--





--



"Max" wrote:

One way ..

Assume col A in Sheet1 is to be compared with col D in Sheet2

In Sheet1,

Put in say, E2:
=IF(A2="","",ISNUMBER(MATCH(A2,Sheet2!D:D,0)))
Copy down to the last row of data in col A. Now you can autofilter on col E.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ajk" wrote:
I want to merge two sheets and use the merged data in a new sheet.

Both my sheets contains similar info but there are fields that differ.

I need Column A from one sheet to look in Column D of the other one to see
if that one contains the same info. A simple return like False or True would
be enough for me.

One sheet contains 2500 entries and the other 4500.

I'll filter the results afterwards.

Any help would be appreciated

kubersluiper