
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 
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 11:59 AM. 

Copyright © 20052007 MacNN. All rights reserved.
Powered by vBulletin® Version 3.8.8
Copyright ©2000  2017, vBulletin Solutions, Inc.