I want to reference another cell, and if it has a certain value (only 5 options), then I want to output something else in it's stead.
So, for example, if 'Sheet2!A1=ABC, then instead of putting ABC, I want it to say XYZ
I created another sheet with the assigned co-values, if that helps. I thought I might could just point the reference to another reference, but I can't get the if then to work.
Is there another formula?
What am I missing?
Thanks in advance.
So, for example, if 'Sheet2!A1=ABC, then instead of putting ABC, I want it to say XYZ
I created another sheet with the assigned co-values, if that helps. I thought I might could just point the reference to another reference, but I can't get the if then to work.
Is there another formula?
What am I missing?
Thanks in advance.