Well, by definition whatever is in C4 is in column C, so perhaps that portion
of your question isn't stated correctly. Matter of fact, your entire
question is pretty ambiguous. Can you try to state it a little more clearly,
perhaps with an example?

"Deanna" wrote:

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.