I need to get a formula for the following:

Search Column "C" for what is in "C4", if "C4" found in Column "C", search
Column "B" for "A6", if "A6" found in Column "B" get the sum from Column "A"

Sounds confusing I know

Please get back to me if you think you may be able to help.