Quote:
Originally Posted by xor
Marcia, IFERROR was new in Excel 2007 and it works fine with both INDEX and MATCH.
If you don't want or can't use IFERROR then use =IF(ISERROR(....
|
I "sit down" corrected xor. Since the advent of MS Excel, the formulas I used was just the MDAS (multiplication, division, addition, subtraction) operations until two years ago when I started exploring and maximizing the many features of the program. I am wondering what's caused the formula i gave to Stai to return error messages when I had made sure that it was OK before posting it.