How to check one cell value to diffrent cell

[Adarsh Nath]

How to check one cell value to diffrent cell and check the condition and if
fulfils the condition than return a value from a different cell to the cell
we Started comparing

 

[Don Guillett]

Care to explain.

 

[Dave Peterson]

dim Cell1 as range
dim Cell2 as range
dim cell3 as range

set cell1 = somecellinyourcode1
set cell2 = somecellinyourcode2
set cell3 = somecellinyourcode3

if cell1.value = cell2.value then
cell1.value = cell3.value
end if