If cell A1 contains a contact's name I want cell A2 to automatically
return a response of "Lead" and if cell A1 is blank I want cell A2 to
remain blank

I assume I need a formula in A2 to this effect but am not sure how to
make it recoginze it correctly.

=IF(A1=???,"Lead")

The question marks in red is what i don't know what to say.


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=498498