| 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. |
| 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 | |||
Threaded Mode
