Matching column in different sheet

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
 
J

Jacob Skaria

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Sheet #'s, but leave cell reference 3
Cross-Referencng numbers between worksheets 3
Fill in columns by matching a value on another sheet 3
Need a Macro to combine 1-5 sheets in one sheet 1
Automatic Page Number and Sheet Names? 2
formula to bring value from another sheet with different spaces 5
Page Numbers/Names listed on a Summary sheet? 5
Excel VBA to move cells to sheet2 based on selection in sheet1 0

Top