Previous Topic Next Topic

Compare 2 columns if it matches all columns must go toSheet2

Reinette - Jul 7, 2022 at 01:04 PM
abdelfatah_0230 Posts 73 Registration date Thursday July 18, 2019 Status Member Last seen July 23, 2022 - Jul 23, 2022 at 05:24 AM

Hello,

Thank you for putting the time aside to help me.

There are 2 sheets, Summary and Journal.

Step 1: In the Summary sheet, I added Column E to check if there is a match between Column D and F. If there is a match, the records should be shown on the Journal sheet. 
Step 2:  In the Summary sheet, there is a 1 in Column B and a 9 in Column C the data should go to the Journal sheet.

Your help is much appreciated.

Windows / Edge 103.0.1264.44

Related:

1 reply

Answer 1 / 1
abdelfatah_0230 Posts 73 Registration date Thursday July 18, 2019 Status Member Last seen July 23, 2022
Jul 23, 2022 at 05:24 AM

Hi ,

should  issue  some  the  pictures  before  and  after   until others members  can  help  you .

best  regards,

abdelfattah
0

Similar discussions

Extract identical cells of 2 columns (excel)
Little bit lost -
keliza -

3 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses