Question on conditional formula

**a_driga** · 08-14-2011, 05:29 AM

Hello all!

I have the following case: (please see the attached file)

As you can see, I have 3 different cases for the:
Yes: row 3, column C, D, E
No: row 3, column D, G
Maybe: row 3, column E

I would like to create a formula in column, which pinpoint the “yes” condition
As you can see, in row3 and column I, I have manually written Loc A, Loc D, Loc E.
Is there any way to automate such task?
The only thing that I can think about is the usage of IF function however, the sheer number of combination will be insurmountable in checking each cell and each combination. For example:
Checking 1 combination: 1 if
Checking with 2 combinations equal to 10 if-function and so on.

**DonkeyOte** · 08-14-2011, 05:36 AM

If you have only a handful of columns to process then you can use a formula to do this:

Please Login or Register  to view this content.

For more columns it would be wise to use a User Defined Function to build the string.

**martindwilson** · 08-14-2011, 05:49 AM

are there really meant to be two columns for loc d?

**a_driga** · 08-14-2011, 07:31 AM

DonkeyOte,
Actually there 10 columns.
User defined function as in macro? If yes, it might be a bit difficult since I am not familiar with macro.

Martin,
Thanks for the correction. It is suppose to be only one column for loc D