How to multiply each cell with another in an array

Not sure which data present in which cell can you please attach a sample workbook with expected outcome?

Thanks for the file but I am unable to understand the logic It will be helpful if you add those values nearby the output cell for better understanding.

It looks to me like you want to create a column that computes the product of each combination/permutation. So, in many ways, this looks to me like a combination/permutation type problem (which I never do, so I'm not very good at programming them). My approach might look something like this (comma delimited):

product,Aindex,Bindex,Cindex,Avalue,Bvalue,Cvalue
=product(I2:K2),1,1,1,index(A1:A3,F2),copy of I2,copy of I2
copy of E2,1,1,2,copy of I2,copy of I2,copy of I2
...

The part that is left to figure out is what formulas to put in columns F, G, and H that will generate the permutations. In your example, you appeared to generate the permutations in lexicographic order, so if we can come up with a set of cell formulas that will recreate that logic, we should be able to do this. Maybe something like:

aindex,bindex,cindex
1,1,1
if(and(G2=3,H2=3),F2+1,F2),if(H2=3,G2+1,G2),=if(H2=3,1,H2+1)
copy of F2,copy of G2,copy of H2
...

though this might be tedious to extend to larger matrices.

In the spirit of brainstorming, would there possibly be a matrix function/multiplication that could represent this problem? If one could see a matrix representation of the problem, then we could possibly use one of the built in matrix functions (like MMULT()) to get at this.

Cheers, thats an approach I never really thought about using. I did think about using matrices but the problem I had was that I couldnt think/remember how to create a function which represented what I was doing. Its been a long time since I did anything with matrices. You're right about me using a lexicographic order when I did it, but any order would be ok, its just what came to mind first.

Ive come up with one way of doing it which involves loops, and once again because my knowledge of programming is rather basic ive done it from a first principle approach which is probably very inelegant, and ive used a goto to create the loop which I think is probably a no-no. Anyway this is what I came up with:

Sub test()

'Define NL as the last row with information in the A column in the Main worksheet.
Dim NL As Long
    NL = Worksheets("Main").Range("A1").End(xlDown).Row

'Define FL as the last row with information in the F column in the Main worksheet
Dim FL As Long
    FL = Worksheets("Main").Range("F65536").End(xlUp).Row
    
'Define x y and z as column names
    
Dim x As Long
Dim y As Long
Dim z As Long
    
x = 1
y = 1
z = 1
    
'Beginning of Loop
    
iLoop:
 
    If y > NL Then
        x = x + 1
        y = 1
        z = 1
    End If
    
    If x > NL Then End

    If z <= NL Then
    
        'Calculate the values of x*y*z
        Worksheets("Main").Cells(FL, 6).Value = Worksheets("Main").Cells(x, 1) * Worksheets("Main").Cells(y, 2) * Worksheets("Main").Cells(z, 3)
        'Write the co-ordinates in adjactent cell for reference
        Worksheets("Main").Cells(FL, 5).Value = x & ", " & y & ", " & z
        z = z + 1
        FL = FL + 1
    

        Else

            z = 1
            y = y + 1

    End If

GoTo iLoop


End Sub

and ive used a goto to create the loop which I think is probably a no-no.

I don't know that it is a no-no, but I think a lot of programmers would use it as a method of last resort. I think I would have used For...Next loops (http://msdn.microsoft.com/en-us/libr...=VS.71%29.aspx) for creating the permutations (pseudocode):

m=0 'm will count our position in the output array
for x=1 to n 'n is the number of rows in each vector
for y=1 to n
for z=1 to n
m=m+1
resultarray(m)=A(x)*B(y)*C(z)
next z
next y
next x