Value in cell refers to value in another cell

  • Thread starter Thread starter morten
  • Start date Start date
M

morten

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
 
=B1*INDIRECT("'Latter'!A"&Pay!A1)

in Danish

=B1*INDIREKTE("'Latter'!A"&Pay!A1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
setting cell values based on a 3rd cell 4
Excel formula, sum the value cell and if empty cell left blank 0
SUMIF "value if false" not working 2
transfering cell values progressively through worksheets 8
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
Problem in displaying number 4
if one cell were to equal __ what would the value in another cell 2

Back
Top