Create a nesting formula w/ multiple conditions based on fields w/VLOOKUP

I have an excel 2007 formula/macro that is far to complex for me to create. Here is what I am trying to do.

I have a workbook that has multiple sheet ties for auto filling. I want to look in column/field C66 and if (RD) is part of the text I want S66 to be 0 otherwise =R66. NOTE: the text that appear in the cells of column C are as a result of an automated population from the below VLOOKUP formula;

=IF(B65="","",VLOOKUP(B65,'Combined Price Master 1-12-2011'!A1:G3246,2,FALSE))
Is this achievable? I want to drag this formula down to Cell S79.