• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

Formula help. IF(AND(OR(

In the following formula how do I point the value to another sheet tab?


,$M$3,0)  currently points to the same sheet tab the formula is in.

How would I rewrite the formula so the target value is?  say  Sheet2$M$3,0)  ??
1 Solution
barry houdiniCommented:
Just use the sheet name followed by !, i.e.


If the sheet name has any spaces (or consists of only numbers) then you also need single quotes around it like this - if sheet was called sheet two

=IF(AND(OR(E11="4CIR",E11="3CIR"),F11=1066.8),'sheet two'!$M$3,0)

regards, barry
RWayneHAuthor Commented:
EXCELent!!  Thanks. -R-
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now