Loop this formula?

[providence]

Hi, just wondering is it possible to create a loop for this formula?

Please Login or Register  to view this content.

Basically its in every cell, I add 1 to C, so it keeps going, C6, C7, C8, C9, etc?

[xladept]

Not sure what you want - is this it?

Please Login or Register  to view this content.

[protonLeah]

I don't understand what you mean by a "loop". However, the formula:

Please Login or Register  to view this content.

in sheet1 will get the row number of the value in column B of sheet1 that matches sheet2, A2 and create the address Cn
and multiply the sheet2, B2 number by what's in Cn
or this one (preferred):

Please Login or Register  to view this content.

[providence]

thanks for the quick reply guys
attached is my excel file
https://dl.dropbox.com/u/48832745/test1.xlsx

Basically I want to create a formula that I can just drag it down to the next row.
What I did is I created a simple drop down options, it shows the different products, if I select "Product 1", the price reflecting to Product 1's should display.
I cant simply copy the formula it wouldnt work since A2 is always fixed to A2. Any suggestions?

[Fotis1991]

Hi

Do you mean something like this?

[olasa]

Try with this formula in cell E3:
=INDEX(Sheet2!$B$2:$B$9;MATCH($B3;Sheet2!$A$2:$A$9;0))*$C3
and copy down
//Ola

[Cutter]

Going by your original post, you just need a couple of $'s in your formula:

=IF(B3=Sheet2!A$2,C3*Sheet2!B$2

(and complete the rest of the formula) and drag down

The $ locks the row references so that the A2 and B2 will stay the same when you drag down. That is called "absolute referencing".