wilg
05-28-2012, 08:02 PM
Hi there, this is a formula question as opposed to vba but I needed some help...
I have 3 columns with info from a schedule on it.
I want a formula for if column A has the word "center" on any row above from row 7 and on then the cells below will remain "" or blank.
The same with column B and C. If the word center is in column A then the rows and columns below will be "" blank.
I dont quite understand if vlookup or match will work for this instance for me?
Any help or direction is appreciated.
I have 3 columns with info from a schedule on it.
I want a formula for if column A has the word "center" on any row above from row 7 and on then the cells below will remain "" or blank.
The same with column B and C. If the word center is in column A then the rows and columns below will be "" blank.
I dont quite understand if vlookup or match will work for this instance for me?
Any help or direction is appreciated.