Conditional Cells Filing
Solved/Closed
Branok
Branok
- Posts
- 7
- Registration date
- Friday September 11, 2015
- Status
- Member
- Last seen
- October 9, 2015
Branok
- Posts
- 7
- Registration date
- Friday September 11, 2015
- Status
- Member
- Last seen
- October 9, 2015
Related:
- Conditional Cells Filing
- Help- conditional cell formatting ✓ - Forum - Excel
- If cell contains text then return value multiple conditions ✓ - Forum - Excel
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Conditional formatting excel if another cell contains text ✓ - Forum - Excel
- Leaving a cell value unchanged if a condition is false excel - Forum - Office Software
2 replies
Mazzaropi
Sep 11, 2015 at 09:18 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Sep 11, 2015 at 09:18 AM
Branok, Good morning.
Try to use:
A1 --> =IF(ISNUMBER(MATCH("Failure",C1:C20,0)),B1,"")
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
A1 --> =IF(ISNUMBER(MATCH("Failure",C1:C20,0)),B1,"")
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Branok
Sep 11, 2015 at 09:54 AM
- Posts
- 7
- Registration date
- Friday September 11, 2015
- Status
- Member
- Last seen
- October 9, 2015
Sep 11, 2015 at 09:54 AM
Hallo Mazzaropi,
Thank you for your advice,
but unfortunately it doesn't work for some reason,
it show an error...
What i need in brief, is to Fill CELL A1 with text from CELL B1(in this cell is text describing an procedure required) if any (one or more) of CELLS in COLUMN C contains world "Failure".
I am getting hopeless :)
Thank you for your advice,
but unfortunately it doesn't work for some reason,
it show an error...
What i need in brief, is to Fill CELL A1 with text from CELL B1(in this cell is text describing an procedure required) if any (one or more) of CELLS in COLUMN C contains world "Failure".
I am getting hopeless :)