Jun 24 2020 12:24 AM
Hi, I'm new to Excel and looking for guidance. Sorry if I'm wasting your time. I need to match the data in Sheet2 to Sheet1 so that it marks an "x" in the box for the corresponding plant species and PCTID. Any help would be greatly appreciated. Thanks, Anna.
Jun 24 2020 12:53 AM
Solution
How about this?
In B1 on Sheet1
=IF(COUNTIFS(Sheet2!$B$2:$B$45,$A2,Sheet2!$A$2:$A$45,B$1),"X","")
and then copy it across and down.
I also made a conditional formatting rule to highlight the cells with "X" in them.
Please refer to the attached for more details.
Jun 24 2020 06:02 PM
@Subodh_Tiwari_sktneer thank you so much, that has been a great help!
Jun 24 2020 12:53 AM
Solution
How about this?
In B1 on Sheet1
=IF(COUNTIFS(Sheet2!$B$2:$B$45,$A2,Sheet2!$A$2:$A$45,B$1),"X","")
and then copy it across and down.
I also made a conditional formatting rule to highlight the cells with "X" in them.
Please refer to the attached for more details.