Mandatory Input of a Cell

[newfie51971]

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]

I'd use an adjacent cell that was formatted in big bold red letters:

=if(a1<>"","","<-- Please enter something here!"

 

[Gord Dibben]

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