Conditional Cells Filing [Solved/Closed]

Report
Posts
7
Registration date
Friday September 11, 2015
Status
Member
Last seen
October 9, 2015
-
Posts
7
Registration date
Friday September 11, 2015
Status
Member
Last seen
October 9, 2015
-
Hello guys :),
I use Excel 12.
What I need help with is a conditional filling of cells, based on values in different cells/in the certain row.
I ll try describe what I need on example.

Legend:

CELL A - Cell i need fill with information from cell B
CELL B- Cell always containing "text" which (conditionally) I'd like to have in Cell A
CELL C (It would be better if applicable on whole row) - The Cell, which might contain different VALUES (Success, Failure, N/A)

Example:
I need CELL A to be filled by text from CELL B, under condition that there is a specific value in CELL C (VALUE i am interested in: Failure).
Even better would be having CELL A filled with text from CELL B when desired condition appears in any cell in row or column.

Than you for help in advance,
Have a nice day :)


2 replies

Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
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
Posts
7
Registration date
Friday September 11, 2015
Status
Member
Last seen
October 9, 2015

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 :)