Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing cells when they are not exactly the same | Excel Discussion (Misc queries) | |||
Comparing cell contents with different reference cells | Excel Worksheet Functions | |||
comparing cells | Excel Worksheet Functions | |||
comparing a column of cell and then copy info to other cells | Excel Discussion (Misc queries) | |||
Formula for comparing two cells | Excel Worksheet Functions |