![]() |
#5
|
||||
|
||||
![]()
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)
__________________
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 |
Tags |
bug, lookup |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lookup | angie.chang | Excel | 1 | 07-27-2012 09:45 PM |
![]() |
Karen222 | Excel | 3 | 01-10-2012 05:41 AM |
![]() |
aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |
![]() |
Grapejuice | Excel | 2 | 10-15-2008 02:02 PM |
Add-In:How to add command right click command bar | phang | Outlook | 0 | 01-15-2007 02:53 AM |