Hey all - quick question.

I have two sheets.

On Sheet S098, I have two colums starting at C2 and D2. And then on S098TOC, I have two columns starting at D4 and G4.

Basically what I want is kind of simple, but difficult to explain, basically, these are Upstream and Downstream Manholes, and I want a formula that searches S098TOC to see if there are a matching set to what is in S098, and puts a 'C" in a different column on S098.

So if C2=S098-001 and D2-S098-002, then I want it to search S098TOC for a matching set in the same row.. So for example, if on D25 there was S098-001 and G25 was S098-002, it would put a C on Q2 of S098.

So basically we're looking for a matching SET, in the same order, between the two sheets.

Can anyone help? Thanks.