Please not that MATCH work with option 0 for Table 1.x It does not work with option 1. However MATCH with option 1 works for Table 2.x regardless that the data are not sorted. Something similar happened with LOOKUP.