Previous Topic Next Topic

Conditional Cells Filing

Solved/Closed
Branok
Posts
7
Registration date
Friday September 11, 2015
Status
Member
Last seen
October 9, 2015
 - Sep 11, 2015 at 08:00 AM
Branok
Posts
7
Registration date
Friday September 11, 2015
Status
Member
Last seen
October 9, 2015
 - Sep 11, 2015 at 09:54 AM
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
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
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
0
Answer 2 / 2
Branok
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 :)
0