Check out this web page of Debra Dalgleish for instructions:

http://www.contextures.com/xlFunctions02.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Evelyn" wrote in message
...
I want to creat a formula that allows data to be automatically entered into
a
cell if two conditions match, i.e.

Enter Project Number then it automatically enters the Project name in the
next cell:

010101 then ABC Project
010506 then DEF Project