combine IF and IFERROR

[johnandrews]

Can I condense the below formula?

Please Login or Register  to view this content.

In other words, it should say 'bad' either if the VLOOKUP returns 0, or if C3 is blank making VLOOKUP return N/A error.

[rajansettu]

Hi,

May be this one will work.,

Please Login or Register  to view this content.

[johnandrews]

Not much different :-(

Is there a way I say 'bad' only once?

[rajansettu]

Hi,

I can't get actually what you want will you able to share some sample excel files for reference..

Please Login or Register  to view this content.

[johnandrews]

Sample attached.

The formula is in Column B:

Please Login or Register  to view this content.

In other words, it should say 'bad' if either the VLOOKUP returns 0 or Column a is blank.

I would like to learn how, but mentioning 'bad' only once. It's a skill I'll use to make a lot more things concise.

[Bobsone]

Hi
Although this still has "Bad" twice, I am posting this so you can check the following formula to ensure it returns what you want;

It returns "Bad" when the VLOOKUP returns 0, or when C3 is blank and returns "Good" when C3 has a value and the VLOOKUP returns a value which is greater than 0.

=IFERROR(IF(VLOOKUP(C3,Sheet1!G1:H26,2,FALSE)>0,"Good","Bad"),"Bad")

Hope this helps

[Speshul]

Do a find and replace on column E, replace 0 with Bad and 1 with Good then just use

=IFERROR(VLOOKUP(A1,D:E,2,0),"Bad")

[FlameRetired]

Not much of a change from yours:

Please Login or Register  to view this content.

A change.....but.

Please Login or Register  to view this content.

[johnandrews]

Speshul that's a great idea. Thank you..