macro or functions to identify same values in two columns

[rsami]

My problem is related to the excel sheet that i have attached here.In this work sheet you can see that there are 2 tables.There are 6 entries(values) under column C under the first table(C9:C14). First i should select first entry that is c9 and i should find which cell under column L consist with the value which is same as the value in cell C9.(in this example value of the cell C9=value of the cell L16). When that cell under column L is selected, the values in the row (D9:H9)(array of values) corresponding to the cell c9 should be multiplied with the values in the row(M16:Q16)(array of values) corresponding to the matched cell(L16) under column L and the results should be stored in the cell(I9) in column I which is corresponding to the cell (c9).And this should be done for all the values in column C (in this example values under column c is fixed but in the real situation it can be vary).

how can i do this with excel VBA(macro) or is there any way to do this task using build in function in excel(if,match.......etc)

I appreciate any help from you

[rsami]

i tried this task to do using if loops.but it's very difficult,
please give me an instruction to do this

[rsami]

I'm very confused with this problem.please help me to solve this problem.
i have attached the excel sheet too

[watersev]

hi, rsami, may be sort of that

[rsami]

please help me if you know the answer

[rsami]

hi, rsami, may be sort of that

Thanks very much.
I'll try it and let you know
thanks again