Change cell referance based on value

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

A1 in sheet1 contains a reference to a cell in sheet2:

=sheet2!G4

what I want to include in the above formula is a reference to a cell value
in sheet1 B1:

=IF(NOT(B1="option1"),=sheet2!G4,(B1="option2"),=sheet2!K7)

The above is clearly not correct but is only a way to illustrate what I am
trying to explain. If you find it difficult to make sense of it I will try
to explain in a better way.

Pat
 
I am not sure on your "Not"
but try
=if(sheet1!B1="option1",sheet2!G4,if(sheet1!B1="option2",sheet2!K7,"otherwise"))
Note I used the same lowercase "sheet" you did, Make sure they match your
actual sheet names.

this equation has the cell equal sheet2!G4 if sheet1!B1="option1"
I could interpret you equation in other ways.

Also if the equation is on sheet 1 you do not have to have the sheet1! in
the equation.
 
Thankyou BJ


bj said:
I am not sure on your "Not"
but try
=if(sheet1!B1="option1",sheet2!G4,if(sheet1!B1="option2",sheet2!K7,"otherwise"))
Note I used the same lowercase "sheet" you did, Make sure they match your
actual sheet names.

this equation has the cell equal sheet2!G4 if sheet1!B1="option1"
I could interpret you equation in other ways.

Also if the equation is on sheet 1 you do not have to have the sheet1! in
the equation.
Click to expand...
 
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

Variable reference in a function 3
Cell Reference 1
Cell highlighting question 4
display a value from Sheet1-A1:A10 in Sheet2-B1 2
if statement, change cell only if true 4
Countif contains a word in a reference cell 3
comparing two sheets og copy value 8
Excel VBA to move cells to sheet2 based on selection in sheet1 0

Back
Top