Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a condtional function that....
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a condtional function that....
Not sure, maybe you mean something like,
In C1: =IF(COUNTA(A:A)=0,"",B1) and with C1 copied down -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a condtional function that....
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a condtional function that....
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a condtional function that....
Not sure, but sounds like a VLOOKUP* may be suitable
You might want to try Debra's page at: http://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="","",IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...) )) But do hang around awhile for Bob's response .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "John" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a condtional function that....
Line:
=IF(A2="","",IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...) )) reads better as: =IF(A2="","",IF(ISNA(VLOOKUP(A2, ...)),"",VLOOKUP(A2, ...))) Lookup values are assumed in A2 down -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |