SOLVED

Help with an R1C1 reference in a function

%3CLINGO-SUB%20id%3D%22lingo-sub-1477773%22%20slang%3D%22en-US%22%3EHelp%20with%20an%20R1C1%20reference%20in%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1477773%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20reference%20the%20cell%20immediately%20to%20the%20left%20of%20a%20cell%20that%20contains%20this%20function%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIF(RC%5B-1%5D%3D%22value%22%2C%22output%22%2C%20%22%22)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...and%20I%20can't%20figure%20out%20what%20is%20wrong.%20It%20seems%20simple%20enough%2C%20but%2C%20I'm%20not%20the%20brightest%20bulb%20on%20the%20string%2C%20so%2C%20your%20help%20is%20very%20welcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1477773%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1477786%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20R1C1%20reference%20in%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1477786%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660787%22%20target%3D%22_blank%22%3E%40Ben72%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20didn't%20shift%20on%20R1C1%20reference%20mode%20in%20options%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20498px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199792i0D5158BE43D9A923%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481312%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20R1C1%20reference%20in%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481312%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20certainly%20did%20not.%20Thank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481636%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20R1C1%20reference%20in%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481636%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660787%22%20target%3D%22_blank%22%3E%40Ben72%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I am trying to reference the cell immediately to the left of a cell that contains this function:

 

=IF(RC[-1]="value","output", "")

or

=IF(EQUALS(RC[-1],"value"),"output","")

 

...and I can't figure out what is wrong. It seems simple enough, but, I'm not the brightest bulb on the string, so, your help is very welcome.

3 Replies
Highlighted

@Ben72 

Perhaps you didn't shift on R1C1 reference mode in options

image.png

Highlighted
Best Response confirmed by Ben72 (Occasional Contributor)
Solution

@Sergei Baklan ,

 

I certainly did not. Thank you for your help!

@Ben72 , you are welcome