Previous Topic Next Topic

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

Answer 1 / 2
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
 147
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
Answer 2 / 2
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 :)
Ask a question