comparing 2 cells where 1 is a cell with a formula

[colmkav]

Anyone know how to 2 cells to see if they hold the same value when l
has a formula in it

eg in cell R2 I have AB and in cell S2 I have vlookup(.....) which
returns the value AB.

If I then enter the formula = if(R2=S2, true, false) I get the result
false when it should be true.

 

[David Biddulph]

I guess that one or other (or both) of your cells have spaces or other
additional characters beyond what you're seeing.

Do =LEN(R2) and =LEN(S2) both return 2? If not, you may need to look at the
TRIM or CLEAN functions.

Note that you don't need the IF() function; you should get the same answer
from =R2=S2

 

[colmkav]

I guess that one or other (or both) of your cells have spaces or other
additional characters beyond what you're seeing.

Do =LEN(R2) and =LEN(S2) both return 2? If not, you may need to look at the
TRIM or CLEAN functions.

Note that you don't need the IF() function; you should get the same answer
from =R2=S2
--
David Biddulph








- Show quoted text -

thanks. I didnt realise thats all it was. Thought it was because it
was via formula.