Fixed Formula

  • Thread starter Thread starter Tsunamic
  • Start date Start date
T

Tsunamic

When i create a formula from another sheet i can not fixed the link. Examply
the formula is "=sheet2!$A$1" in sheet 1, when i add a column before the
column of the A column then the formula gets the new data as "=Sheet2!$B$1"
but i don't want to excel point the new cell, i want it to be fixed at
"=Sheet2!$A$". Any way to solve this problem?
 
=INDIRECT("sheet2!A1")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| When i create a formula from another sheet i can not fixed the link. Examply
| the formula is "=sheet2!$A$1" in sheet 1, when i add a column before the
| column of the A column then the formula gets the new data as "=Sheet2!$B$1"
| but i don't want to excel point the new cell, i want it to be fixed at
| "=Sheet2!$A$". Any way to solve this problem?
 
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

EXCEL - IF(IFERROR(VLOOKUP question 0
Need help with a formula, please!!! 2
Fill formula down for cells 74 rows apart 3
Complex match 1
Fill Series for Lookup 2
Transpose between sheets 4
formula help 2
Compare formula 2

Back
Top