Matching column in different sheet

  • Thread starter Thread starter Khawajaanwar
  • Start date Start date
K

Khawajaanwar

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
 
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,"")
 
Back
Top