View Single Post
 
Old 01-30-2015, 09:36 AM
Boyko Boyko is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2015
Posts: 8
Boyko is on a distinguished road
Exclamation

Quote:
Originally Posted by Pecoflyer View Post
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.
Reply With Quote