Value Match

[Scarecrowed]

Hi all,

Sorry to ask but i'm a newbie...

It's difficult to explain, I will do my best to be precise.
I got a 3 column table with figures (A-B-C).

The value in G (Sum) must be equal to the value in J (Total). I increase by 1 the A Val (column E) and search the B Val (column H) corresponding to Sum in my table (if the exact value doesn't appear, I calculate it using the column C).

ValUp is a % of B Val and "Total" is the rounded sum of A Val and Val Up.

The aim of the macro is to write the value of the "Sum" matching the "Total" in a cell (e.g L2)
http://imageshack.us/photo/my-images/535/valuematch.jpg/

Thanks in advance.