Ok , the way this should work is:
1) On sheet 2 in the 3 column( C4) starts the calculation with this value.
2) This value of (349.71) is entered into sheet 1 at cell (F2) and goes through another calculation and gave a value of 8934.91 in cell (F9).


3) (F9) is returned to sheet 2 at cell (B4).
4) Now the hard part. How do I get a continues returning values to full up the column from (B5 toB14)?


I have attached the problem,I was hope for just a vlooup but it appears to be more to it.
ITS 2007 excel

Attached Files

Problem1.xlsx (12.1 KB, 16 views)