Put this in E2 then copy down:
=IF(C2=D2, "OK", D2)
--
"Actually, I *am* a rocket scientist." -- JB
(
www.MadRocketScientist.com)
Your feedback is appreciated, click YES if this post helped you.
"Curtis" wrote:
I need a formula in row E (e2:e500) that will look in range c2:c500 for a
value equal to that in range d2:d500.
ex:If there is a value in column c that matches that in column d I want
column e to say "OK". If not to show the value in column d
thanks