Conditional Cells Filing Solved/Closed

Question

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 :)


Configuration: Windows 7 / Firefox 19.0

Mazzaropi · Answer

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

Branok · Answer

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

Conditional Cells Filing

2 responses

Similar discussions

Subscribe To Our Newsletter!