Thread
: [Solved]
It looks like a bug in Lookup command
View Single Post
01-30-2015, 03:46 AM
Pecoflyer
Windows 7 64bit
Office 2010 64bit
Expert
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
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)
Attached Files
Test LOOKUP.xlsm
(30.1 KB, 11 views)
__________________
Using O365 v2503
- Did you know you can thank someone who helped you
? Click on the tiny scale in the right upper hand corner of your helper's post
Pecoflyer
View Public Profile
Find all posts by Pecoflyer