Value in cell refers to value in another cell
 

Hi sorry for being vague but I'm very new to excel and needs some help.

Question:
I uses two sheets: i.e. "pay" and "latter"
I want the value of 'pay!A1' to refer to the cell 'latter!A(pay!A1)'

so that I can use a formula in cell pay!C1 that is something like this:
=SUM(B1 * latter!A(value of pay!A1)

hope you can understand my question :)

regards
Morten T

Value in cell refers to value in another cell
 

=B1*INDIRECT("'Latter'!A"&Pay!A1)

in Danish

=B1*INDIREKTE("'Latter'!A"&Pay!A1)


--

Regards,

Peo Sjoblom

wrote in message
ups.com...
Hi sorry for being vague but I'm very new to excel and needs some help.

Question:
I uses two sheets: i.e. "pay" and "latter"
I want the value of 'pay!A1' to refer to the cell 'latter!A(pay!A1)'

so that I can use a formula in cell pay!C1 that is something like this:
=SUM(B1 * latter!A(value of pay!A1)

hope you can understand my question :)

regards
Morten T

Value in cell refers to value in another cell
 

It works!

Thank you so much :)