Help with INDEX MATCH VLOOKUP functions

[anna_carolyn]

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.

[#2 · Accepted solution]

@anna_carolyn 

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.

[#3]

@Subodh_Tiwari_sktneer thank you so much, that has been a great help! 

[#4]

You're welcome @anna_carolyn!