Well yes if A is blank. Basically, I have a returned material database in
excel in which I enter the items I receive. I have to enter three pieces of
data: the product number, serial number, and the product description. I want
to be able to type the product number in cell A and in turn, get the product
description in cell C. And i want to set up a function for that proceeds
through the entire excel sheet. If you know of an easier way or a better
program to use that would be extremely helpful. Thanks.

"Bob Phillips" wrote:

Do you mean that nothing can be entered in C1 if A1 is blank?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John" wrote in message
...
I'm looking to set up a conditional function for two entire columns.
Rather
than saying if A1="blank" I want to say if any of the cells in column
A="blank" than the corresponding C cell in that row will be "blank." So
that
the c column in the entire spreadsheet is designed around that one formula
contingent upon any cell in the A column. Help would be greatly
appreciated.
thank you