Have a look in the help index for LOOKUP or VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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