software

I'm looking to set up a conditional function for two entire columns. Rather
than saying if A1=quot;blankquot; I want to say if any of the cells in column
A=quot;blankquot; than the corresponding C cell in that row will be quot;blank.quot; 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

Not sure, maybe you mean something like,
In C1: =IF(COUNTA(A:A)=0,quot;quot;,B1)
and with C1 copied down
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;Johnquot; gt; wrote in message
...
gt; I'm looking to set up a conditional function for two entire columns.
Rather
gt; than saying if A1=quot;blankquot; I want to say if any of the cells in column
gt; A=quot;blankquot; than the corresponding C cell in that row will be quot;blank.quot; So
that
gt; the c column in the entire spreadsheet is designed around that one formula
gt; contingent upon any cell in the A column. Help would be greatly
appreciated.
gt; thank you
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)

quot;Johnquot; gt; wrote in message
...
gt; I'm looking to set up a conditional function for two entire columns.
Rather
gt; than saying if A1=quot;blankquot; I want to say if any of the cells in column
gt; A=quot;blankquot; than the corresponding C cell in that row will be quot;blank.quot; So
that
gt; the c column in the entire spreadsheet is designed around that one formula
gt; contingent upon any cell in the A column. Help would be greatly
appreciated.
gt; thank you
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.

quot;Bob Phillipsquot; wrote:

gt; Do you mean that nothing can be entered in C1 if A1 is blank?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Johnquot; gt; wrote in message
gt; ...
gt; gt; I'm looking to set up a conditional function for two entire columns.
gt; Rather
gt; gt; than saying if A1=quot;blankquot; I want to say if any of the cells in column
gt; gt; A=quot;blankquot; than the corresponding C cell in that row will be quot;blank.quot; So
gt; that
gt; gt; the c column in the entire spreadsheet is designed around that one formula
gt; gt; contingent upon any cell in the A column. Help would be greatly
gt; appreciated.
gt; gt; thank you
gt;
gt;
gt;

Not sure, but sounds like a VLOOKUP* may be suitable

You might want to try Debra's page at:
www.contextures.com/xlFunctions02.html
(there's also a sample book available for d/l on her page)

*with error traps to return blanks if the lookup value is blank, and another
for unmatched cases possibly, something like:
=IF(A2=quot;quot;,quot;quot;,IF(ISNA(VLOOKUP(...)),quot;quot;,VLOOKUP(...) ))

But do hang around awhile for Bob's response ..
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;Johnquot; gt; wrote in message
...
gt; Well yes if A is blank. Basically, I have a returned material database in
gt; excel in which I enter the items I receive. I have to enter three pieces
of
gt; data: the product number, serial number, and the product description. I
want
gt; to be able to type the product number in cell A and in turn, get the
product
gt; description in cell C. And i want to set up a function for that proceeds
gt; through the entire excel sheet. If you know of an easier way or a better
gt; program to use that would be extremely helpful. Thanks.
Line:
gt; =IF(A2=quot;quot;,quot;quot;,IF(ISNA(VLOOKUP(...)),quot;quot;,VLOOKUP(...) ))

reads better as:
gt; =IF(A2=quot;quot;,quot;quot;,IF(ISNA(VLOOKUP(A2, ...)),quot;quot;,VLOOKUP(A2, ...)))

Lookup values are assumed in A2 down
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--