multiple conditions

[jkenney111]

I need a particular cell (we'll say A25) to return a value of 1,2,3 or 4 depending on the following conditions:

Returns 1 IF (G15="L" and H15="I" and K15="P") otherwise........
Returns 2 IF (G15="L" and H15="I" and K15="S") otherwise........
Returns 3 IF (G15="L" and H15="N" and K15="P") otherwise........
Returns 4 IF (G15="L" and H15="N" and K15="S") and finally........
Leaves blank IF (G15="A")

I've tried nesting IF statements but obvously I have more than 7!

[oldchippy]

There are only 5 IF's so you could use this

=IF(G15="","A",IF(AND(G15="L",H15="I",K15="P"),1,IF(AND(G15="L",H15="I",K15="S"),2,IF(AND(G15="L",H15="N",K15="P"),3,IF(AND(G15="L",H15="N",K15="S"),4,0)))))

[jkenney111]

How would I alter this to recognize a series of numbers insted of "P"

For instance, in the first IF(AND statement I need K15= to recognize the values 1-4 instead of "P"

Thanks for the help

[oldchippy]

Do you still want it to return 1 if TRUE for L I, and 3 if TRUE for L N, if so then

=IF(G15="","A",IF(AND(G15="L",H15="I"),IF(OR(K15=1,K15=2,K15=3,K15=4),1,0),IF(AND(G15="L",H15="I",K15="S"),2,IF(AND(G15="L",H15="N"),IF(OR(K15=1,K15=2,K15=3,K15=4),3,0),IF(AND(G15="L",H15="N",K15="S"),4,0)))))

[jkenney111]

Works perfectly........thanks a lot

[oldchippy]

No problem - thanks for the feedback

[jkenney111]

1=Primed
2=White
3=Linen White
4=Univ. White
5=BLK Walnut
6=Fruitwood
7=Teak
8=Maple
9=Prov
10=Span Oak
11=White Oak
12=Clear

=IF(C15=1,"Primed",IF(C15=2,"White",IF(C15=3,"Linen White".........and so on. Its my understanding that I cannot nest this entire formula in this format.

Could you offer another suggestion?

[oldchippy]

Take a look at this previously answered question on multiple colours

http://www.excelforum.com/showthread.php?t=582266

[jkenney111]

Thanks for the suggestions........but I'm afraid it didn't make any sense to me. Is there another way without using VBA?

[oldchippy]

Sorry, sent you up the wrong path completely there. I was in a hurry to get home and didn't read it properly.

Try this, if you have your list 1-12 and different finishes in say A1:B12, then you can use a vlookup

=VLOOKUP(C15,A1:B12,2)

[jkenney111]

Thanks.......it works perfectly

[oldchippy]

Good - Glad we got there in the end. Thanks for the feedback.