MacNN Forums (http://forums.macnn.com/)
-   Applications (http://forums.macnn.com/applications/)
-   -   Excel Help with If - Match formula (http://forums.macnn.com/82/applications/499093/excel-help-with-if-match-formula/)

 
Sosa Mar 21, 2013 12:52 PM
Excel Help with If - Match formula
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
 
Sosa Mar 21, 2013 03:48 PM
Got it, the trick was to use Iferror(IF(MATCH(A6,A40:A46),"High","Calculate Below")
 
All times are GMT -4. The time now is 09:31 PM.

Copyright © 2005-2007 MacNN. All rights reserved.
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2016, vBulletin Solutions, Inc.


Content Relevant URLs by vBSEO 3.3.2