Multiple IF Statements with VLOOKUP and IFERROR

[IESEnergy]

How do I get cell BA to show blank instead of False when Column AT is blank?

=IFERROR(IF(AT6="Low Temp. (-10-10°F)",VLOOKUP(AY6,Codes!CP3:CV33,6,FALSE),IF(AT6="Med. Temp. (33-41°F)",VLOOKUP(AY6,Codes!CP3:CV33,4,FALSE),IF(AT6="Air Conditioned",VLOOKUP(AY6,Codes!CP3:CV33,2,FALSE),IF(AT6="Outdoor",VLOOKUP(AY6,Codes!CP3:CV33,2,FALSE),IF(AT6="None"," ")))))," ")

 

[Marcílio_Lobão]

IESEnergy, Good morning.

Try to use:

=IFERROR(IF(AT6="Low Temp. (-10-10°F)", VLOOKUP(AY6,Codes!CP3:CV33,6,FALSE), IF(AT6="Med. Temp. (33-41°F)", VLOOKUP(AY6,Codes!CP3:CV33,4,FALSE), IF(AT6="Air Conditioned", VLOOKUP(AY6,Codes!CP3:CV33,2,FALSE), IF(AT6="Outdoor", VLOOKUP(AY6,Codes!CP3:CV33,2,FALSE), IF(AT6="None"," " ," " )))))," " )

Red part is missing part.

Hope it helps.

Marcílio Lobão

 

[IESEnergy]

Thank you it worked perfectly!

 

[Aladin Akyurek]

A picture is not much of use... That said:

Try...

=IFERROR(IF(OR(AT6="",AT6="none"),"",VLOOKUP(AY6,Codes!$CP$3:$CV$33,
       VLOOKUP(AT6,{"Air Conditioned",2;"Outdoor",2;"Med. Temp. (33-41°F)",4;"Low Temp. (-10-10°F)",6},2,0),0)),"")

 

[Jonmo1]

FYI

" " is NOT blank. It's a Space.
"" would be better, yet still not truely blank.

 

[IESEnergy]

A picture is not much of use... That said:

Try...

=IFERROR(IF(OR(AT6="",AT6="none"),"",VLOOKUP(AY6,Codes!$CP$3:$CV$33,
       VLOOKUP(AT6,{"Air Conditioned",2;"Outdoor",2;"Med. Temp. (33-41°F)",4;"Low Temp. (-10-10°F)",6},2,0),0)),"")

Thanks. I like this formula much better than my original one. Sorry about the picture. I wasn't sure if it would be needed or not.

 

[Aladin Akyurek]

Thanks. I like this formula much better than my original one. Sorry about the picture. I wasn't sure if it would be needed or not.

No problem. You are welcome.