Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
conditional formula | Excel Worksheet Functions | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
conditional formula | Excel Worksheet Functions |