使用excel vba中的匹配方法出错1004

I'm working in two different sheets in excel, each which have a set of about 1200 ID numbers. When referencing sheet 1 (RG Summary), I'm trying to find which row number the ID shows up on sheet 2 (Purchasing Matrix). This is to ultimately do some conditional formatting on sheet 1, where the sheet 2 IDs have specific values on their row. I really know very little about VBA (I'm just doing a side job for my internship this summer), so I'm sure I could be missing some major concept... But currently I get this errorI'm working in two different sheets in excel, e