comparing 2 cells where 1 is a cell with a formula
 

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.

comparing 2 cells where 1 is a cell with a formula
 

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

"colmkav" wrote in message
ps.com...
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.

comparing 2 cells where 1 is a cell with a formula
 

On 26 Jul, 16:09, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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

"colmkav" wrote in message

ps.com...



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.- Hide quoted text -

- Show quoted text -

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