Currenlty I Am Facing A Problem

Its Like I Have So Many Values In Columns Which I Have To Match Against A Single Figure Which Is A Combination Of 2 Or 3 Values Or More

For Example Amount Is 1000

It Is The Comination Of Say 500+300+200

Which Equals To 1000 Which I Wanted To Search

So Is There Any Code For This That I Can Match A Single Value Against Its Cobination From A Column Or Whole Sheet


I M In Real Trouble Now

If Anybody Can Help

I L Be Really Thankful