Trying to Thread Multiple IF-AND Formulas together

[jprimalion]

Hi there, I've already tried researching and experimenting on different ways to fix the problem that I have with my workbook. I am trying to nest together multiple IF AND formulas together.

Scenario:​

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Team Name[/TD]
[TD]Dex Code[/TD]
[TD]Sense 1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Green[/TD]
[TD]GreenYes[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Green
[/TD]
[TD]GreenNo[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Blue[/TD]
[TD]BlueYes[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Blue[/TD]
[TD]BlueNo[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Orange[/TD]
[TD]OrangeYes[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]

So, in this example, let's say:
IF "Team Name"/A2 = "Green" and "Sense 1"/C2 = "Yes", Then "Dex Code" / B2 = "GreenYes", ELSE "Dex Code" / B2 = "GreenNo".
IF "Team Name"/A2 = "Blue" and "Sense 1"/C2 = "Yes", Then "Dex Code" / B2 = "BlueYes", ELSE "Dex Code" / B2 = "BlueNo".
etc.

So basically what I am trying to achieve is to have one formula that the selections will validate all of them in just one cell.

Can anyone help?

Thanks in advance!

 

[JoeMo]

Maybe:

B2=A2&C2

and copy down

 

[jprimalion]

Thanks JoeMo but let's say that everything in Row B will need to go through a validation process.
Like:
IF “Team Name” = “Green”
AND “Sense 1” = “Yes”
THEN “Dex Code” = “GreenYes”
OTHERWISE “Dex Code”=”GreenNo”
BUT IF “Team Name” = “Blue”
AND “Sense 1” = “Yes”
THEN “Dex Code” = “BlueYes”
OTHERWISE “Dex Code”=”BlueNo”
BUT IF “Team Name” = “Orange”
AND “Sense 1” = “Yes”
THEN “Dex Code” = “OrangeYes”
OTHERWISE “Dex Code”=”OrangeNo”

So the thread keeps going on and on until you can get an exact match and I can add up as many conditions if needed.

Did I make any sense on what I'm trying to accomplish?????

 

[JoeMo]

Thanks JoeMo but let's say that everything in Row B will need to go through a validation process.
Like:
IF “Team Name” = “Green”
AND “Sense 1” = “Yes”
THEN “Dex Code” = “GreenYes”
OTHERWISE “Dex Code”=”GreenNo”
BUT IF “Team Name” = “Blue”
AND “Sense 1” = “Yes”
THEN “Dex Code” = “BlueYes”
OTHERWISE “Dex Code”=”BlueNo”
BUT IF “Team Name” = “Orange”
AND “Sense 1” = “Yes”
THEN “Dex Code” = “OrangeYes”
OTHERWISE “Dex Code”=”OrangeNo”

So the thread keeps going on and on until you can get an exact match and I can add up as many conditions if needed.

Did I make any sense on what I'm trying to accomplish?????

You can't apply all those mutually exclusive conditions. If Team Name is not Green or Sense 1 is not Yes, your first condition says return GreenNo. So if, for example, Team Name is Blue then your first condition returns GreenNo which is not what you want.

 

[Jonmo1]

I don't understand how Joe's suggestion would not work for this

Maybe:

B2=A2&C2

and copy down

Excel Workbook
	A	B	C
1	Team Name	Dex Code	Sense 1
2	Green	GreenYes	Yes
3	Green	GreenNo	No
4	Blue	BlueYes	Yes
5	Blue	BlueNo	No
6	Orange	OrangeYes	Yes
Sheet2

 

[jprimalion]

I don't understand how Joe's suggestion would not work for this



Sheet2

*	A	B	C
Team Name	Dex Code	Sense 1
Green	GreenYes	Yes
Green	GreenNo	No
Blue	BlueYes	Yes
Blue	BlueNo	No
Orange	OrangeYes	Yes

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:83px;"><col style="width:83px;"><col style="width:83px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B2 =A2&C2 B3 =A3&C3 B4 =A4&C4 B5 =A5&C5 B6 =A6&C6 <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

One way to find out. Maybe I need to playaround with my worksheet a little more. I thought that there was an easier way to make it more complicated LMAO.thanks for the advise guys.