Advanced Filtering (Nested IFs)?

[kguerrero]

Hi,

In A1 I have a value of 0,1,2,3, or 4
In B1 I want text associated to the value in A1. The Text would be: None, Single, Dual, Triple, Full

So, if in A1 - I enter 2. In B1 "DUAL" will show up

This would be replicated for several rows.

Thanks,

[kguerrero]

Actually, there is more to it.

What I really need

Is to evaluate values in three cells and to populate this into one cell.

In A1, B1, and C1 I'll have values of 0, 1, 2, 3, or 4.

In D1 I'll populate information based off these values.

Example: In A1 I enter 2. In B1 I enter 0. In C1 I enter 4. D1 will then populate with: "A is Dual, B is None, and C is Full."

Thanks

[BarryTSL]

How about - =IF(OR(A1={0,1,2,3,4}),LOOKUP(A1,{0,1,2,3,4},{"None","Single","Duel","Triple","Full"}),"")

[kguerrero]

Barry,

Thanks: This works great for a single comparison.

I need to compare 3 cells and generate one comment.

Currently, I am using your suggestion to generate the comment in to three separate cells, then combining those comments into one cell. Is there an easier way?

Thanks

[xladept]

Hi KGuerrero,

A is Dual,B is None,C is Full

Please Login or Register  to view this content.

You can't be too choosy(!)

[kguerrero]

THAT'S AWESOME! Exactly what I was looking for thanks xladept!

I have one more, new, scenario that I tried to use the CHOOSE function for. This is a binary input (0 or 1). We'll call it D1. Essentially, If D1 is 0 an additional note of "Trash" should be added to the cell. If it is 1 then "Good" is added to the cell.

I added CHOOSE(D1,"Trash","Good") to your suggestion and all D1 values of 1 show up with "Trash" added to the cell and values of 0 result in a #Value error.

When I add CHOOSE(D1+1,"Trash","Good"), The values of 1 add "Good" to the cell appropriately, but the values of 0 do not add anything to the cell. Any help is appreciated.

THANKS!

[kguerrero]

Scratch that ...

The CHOOSE(D1+1,"Trash","Good") worked fine. I Just needed to ensure that "wrap text" was on.

AWESOME!

THANKS!

[xladept]

Hi kguerrero,

Way to go!