I still get occasional #REF!'s with your array* formula when F9 was
repeatedly pressed to regen...

Could it be because the lookup_array (returned by CHOOSE(...))
needs to be sorted in ascending order since match_type 1 is used?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---