Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mandatory Input of a Cell
I have an input template in Excel 2002 that other users will update with
information. I want to make sure they input a description beside the number. How can I make the description cell a mandatory input if they input a number? Thanks, Tammy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mandatory Input of a Cell
I'd use an adjacent cell that was formatted in big bold red letters:
=if(a1<"","","<-- Please enter something here!" newfie51971 wrote: I have an input template in Excel 2002 that other users will update with information. I want to make sure they input a description beside the number. How can I make the description cell a mandatory input if they input a number? Thanks, Tammy -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mandatory Input of a Cell
Maybe you could create a lookup table and a formula in mandatory cell with a
VLOOKUP formula to return the description based upon the input number? Users would only have to enter the number. Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on value. Note the downloadable sample workbooks. http://www.contextures.on.ca/xlFunctions02.html Also see Debra's site for info on Data Validation selection lists for inputting the data if need be. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Tue, 15 Jul 2008 06:47:04 -0700, newfie51971 wrote: I have an input template in Excel 2002 that other users will update with information. I want to make sure they input a description beside the number. How can I make the description cell a mandatory input if they input a number? Thanks, Tammy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make an input in a cell mandatory without leaving it blank | Excel Discussion (Misc queries) | |||
mandatory cell | Excel Discussion (Misc queries) | |||
Require mandatory info input in order for Exel to save changes. | Excel Worksheet Functions | |||
Mandatory cell | Excel Discussion (Misc queries) | |||
Mandatory input in Excel | Excel Discussion (Misc queries) |