Hi Paul,

Am Fri, 8 Jul 2016 10:13:15 -0700 (PDT) schrieb Paul Doucette:

127?!? Agreed. Too convoluted. I need to learn how to use the Index and Match functions. It appears much more straightforward... but I will have to do some studying. Right now I only know that it works, not how.

the INDEX describes a range and MATCH will find the row number. The
different result of --ER18&--ET18 are into the array in the MATCH
formula.


Regards
Claus B.
--
Windows10
Office 2016