Holy Moley, IF AND INDEX MATCH LEFT confusion

Man, the logic of this is killing me trying to keep it all straight.

How can I do the following

I need to look in column G on TABLE sheet
If the value is 2 and
the left 11 characters of column C = "701-000021-" then
on REPORT sheet return "X" otherwise ""

I'm not looking at cell C2 alone. I'm looking at the whole columns. I updated the spreadsheet attachment.

I was trying to use a lookup because I need to look in the whole column for the values. Sometimes I will use "X" as the return, but in other cells I will need to get the result from column C.

I can't use a negative number on a lookup so I was trying to use an INDEX MATCH combination.

On REPORT sheet in cell B3 I need to know if there is a gauge being used for option 2.
First I need to look at TABLE sheet column G to find option 2
For all the option 2 I need to see if there is any that begins with "701-000021-"
If there is then I will put an "X".

On other cells, I will be looking for a different number in column C of TABLE sheet.
If that number exists then I need to put that value in C3 on REPORT sheet.

Here's what I tried without success (not using the LEFT function):

=IF(AND(INDEX('TABLE'!C:C,MATCH("701-000021-103",'TABLE'!C:C)),INDEX('TABLE'!C:C,MATCH("2",'TABLE'!G:G))),"X","")

It sort of looks right in that it puts an X in the right row. When I copy it down to row 9 it puts another X. A9 doesn't have anything to reference so I'm not sure what it is looking at to think there should be an X here.

Yes, that looks very nice. Thank you.

Now for the million dollar question...
When it does find a match, how do I put the value of the match in place of "X"?

Exactly right!

Thanks