return value offset by cols and rows

[roothog]

I have data sheets that I download daily where location of desired data remains in same cells. 1000's of rows, 10 columns. I want to search Col C for certain text (occuring only once in that column). Then I want the figure that is located in G19 (4 cols right, 18 rows down).

I've tried =SUMPRODUCT((C:C="RA")*(OFFSET(C:C,18,4)))
=SUMIF($C$1:$C$3000,"RA",INDEX($C$1:$G$3000,18,MATCH(4,$C$1:$G$3000)))

Neither work. Sample attached...

[JBeaucaire]

Try this:
=INDEX(G:G, MATCH("RA", C:C, 0) +18, 0)