Quote:
Originally Posted by Pecoflyer
1.The LOOKUP vector ( in your case col C) must be placed in ascending order otherwise the results might be wrong ( see https://support.microsoft.com/kb/324986)
2. The MATCH function works perfectly with option 0 (see attached) |
Again, I would like to stress again my question: Why LOOKUP works for Tables 2.x but it does not work for Tables 1.x. In both tables the values in Column C are not in ascending order. The trend in the values is the same in both tables: increasing until certain value and then decreasing.