Hello,
I'm trying to write a formula that will give me one value if a match is true, another value if the match is false. I've prepared this:
=IF(MATCH(A6,A40:A46),"High","Calculate Below")
Something is missing because while I get the true value (High) the false value is #N/A. How do I improve the formula to give me the false value of "Calculate Below?"
The range of cells A40:A46 has text values.
Thank You,
Sosa