using value of another cell as row reference number

  • Thread starter Thread starter charles
  • Start date Start date
C

charles

Hi! How can I use the value from another cell as current row refernce
number, e,g., A(B2)? Thanks in advance.
 
charles said:
Hi! How can I use the value from another cell as current row refernce
number, e,g., A(B2)? Thanks in advance.
Click to expand...

=INDIRECT("A"&B2)

Dave
dvt at psu dot edu
 
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

Copying cell References from Columns to Rows 4
Using cell value to build external reference 11
Excel Conditional Formatting 1
Cell reference between worksheets 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Find data in Range, Return Cell Reference 7
How to have a variable cell reference across sheets? 3

Back
Top