Adding an Argument to an existing IF statement HELP

[cr2crf]

This formula,=IF(COUNTIF(Arrays!$K$24:$K$27,F4),O$1,""), works great and I arrived at it from much help on this board. The formula looks at the array in the Arrays tab (Arrays!$K$24:$K$27) and if F4 is found there it returns what is in O1 (in this case its apples). Now I want to add another argument to the statement. I want to add the argument to look in the V column to see if "Ripe" apears, then return what is in O1. However, when I do, it returns the dreaded #VALUE ! error.

Here is what I did and it failed: =IF(COUNTIFS(V:V,"RIPE",Arrays!$K$24:$K$27,F4),O$1,""). I also tried nesting a Sumproduct in there to no avail.

Would a VLOOKUP work here? How?

I appreciate all the help for us newbies.

 

[cr2crf]

Bump?

 

[JoeMo]

The arrays in your formula must have the same dimensions.

Try:

=IF(COUNTIFS(V24:V27,"RIPE",Arrays!$K$24:$K$27,F4),O$1,"")

 

[cr2crf]

The arrays in your formula must have the same dimensions.

Ugh, they don't. that seems to be my problem. The Arrays at Arrays!$K$24:$K$27 are descriptions that apply to all kinds of fruit. Only when F4 matches one of those descriptions does it return the word "apples" from O$1 to the cell with the formula.