Matching column in different sheet
 

I have data in different sheet1, sheet2 and sheet3, column A of each sheet
have a distinctive number. I need that if any data of sheet 1, sheet 2, sheet
3 a result the whole row will appear in sheet 4

Matching column in different sheet
 

Try the below formula in Sheet4 A1 and copy to the right and down as
required..The formula will populate date with reference to Sheet1; if the
same colA info is present in Sheet2 and Sheet3

=IF(AND(COUNTIF(Sheet1!$A:$A,Sheet1!$A1),
COUNTIF(Sheet2!$A:$A,Sheet1!$A1),
COUNTIF(Sheet3!$A:$A,Sheet1!$A1)),Sheet1!A1,"")

--
Jacob


"Khawajaanwar" wrote:

I have data in different sheet1, sheet2 and sheet3, column A of each sheet
have a distinctive number. I need that if any data of sheet 1, sheet 2, sheet
3 a result the whole row will appear in sheet 4