=IF(A1=A2,"TRUE","")

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"hilltop55" wrote:

I need a formula that will look at cell a1 compare it with a2, if exact
return true, if not exact return nothing.

A1 = Bill A2 = Bill return true
A1 = Bill A2 = Sam return true
A1 = Bill A2 is a blank cell; I don't want the word false return just a
blank cell.
--
Thanks for your help.