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
Bookmarks