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)

Hi,
Hope i have understand ur query, n the sample calculated file will give u what u want. for calculation part see D column of sheet2. If any problem let me know.
Regards,
Nirik

Attached Files

sample (solved).xls (35.0 KB, 19 views)

whether the formula provided by me was same which u were looking for or not. if ur querry solved then mark it as solved.
regards.

you got it, I was over thinking it into a mass problem and its just a if statement ,
Thank you very much
Happy holidays

ps how do i mark it solved?

hii again,
for marking it a solved, just click on thread tool just above the question
mentioned by U & then click on last option.
regards,