I also did it using INDEX and MATCH however, my question was why LOOKUP works fine with Table 2.x but does not work with Table 1.x
The trends of the data in both tables are the same.