CONDITIONAL FORMULA
 

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

CONDITIONAL FORMULA
 

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

CONDITIONAL FORMULA
 

hi
probably a lookup formula.
you should have a small table somewhere with your project numbers and
corrisponding project names. lets say AA1 to AA20 or project numbers and AB1
to AB20 for projecct names.
lets say your are entering the project number in A2. in B2 enter...
=lookup(A2,AA1:AB20,AB1:AB20) or
=LOOKUP(WhatToLookFor,RangeToLookIn,RangeToPickFro m)
The WhatToLookFor should be a single item.
The RangeToLook in can be either horizontal or vertical.
Be careful not to include unnecessary heading in the ranges as these will
cause errors.
The list of information to be looked through must be sorted in ascending
order, otherwise errors will occur.

regards
FSt1

"Evelyn" wrote:

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

CONDITIONAL FORMULA
 

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