Formula that lists out a unique value

[JasonNeedsHelp]

Hello All,

Thanks in advance for any help...

Please see attached spreadsheet.

I need a formula in Column H that will look at Column C and G.

If the Column G has only "BASE" or "Blank" for Column C to return "No WC"
If the Column G has only Anything other then "Base" or "Blank" to state what it is. I've used for example SAW, GOW and HHHC in my example; but this could be anything. But if it has something not Blank or "BASE" to not put in "No WC"

Also, I would want "No WC" to only show up once for that reference number (Column C) as Column C maybe sorted differently, I would only want the "No WC" on the first time it comes up.

Is such a formula possible?

Thanks,

-Jason