Find matching values and return

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.

That works, Tony! Thank you so much!

Sub Macro1()

a = 2

Do While Sheets("S098").Cells(a, 3) <> ""

b = 4
Do While Sheets("S098TOC").Cells(b, 4) <> ""

If Sheets("S098").Cells(a, 3) = Sheets("S098TOC").Cells(b, 4) Then
If Sheets("S098").Cells(a, 4) = Sheets("S098TOC").Cells(b, 7) Then

Sheets("S098").Cells(a, 17) = "C"

End If
End If

b = b + 1
Loop

a = a + 1

Loop

End Sub

Is it looking for matches only in columns D and G or D, E, F and G? Because this macro will not work if it's looking for matches in columns E and F. Hope this helps.

***Sorry, just read you wanted formula, not macro***