VLOOKUP IN Excel not showing error

%3CLINGO-SUB%20id%3D%22lingo-sub-1119545%22%20slang%3D%22en-US%22%3EVLOOKUP%20IN%20Excel%20not%20showing%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1119545%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20has%20any%20one%20had%20a%20problem%20with%20VLOOKUP%20%3CU%3ENOT%3C%2FU%3E%20showing%20an%20error%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20identify%20the%20years%20associated%20with%20unique%20account%20numbers.%26nbsp%3B%20The%20account%20number%20is%20located%20in%20first%20column%20and%20is%20identified%20in%20the%20lookup%20formula.%26nbsp%3B%20It%20is%20searching%20the%20lookup%20table%20organised%20in%20ascending%20order%20with%20no%20duplicates%20(constant).%26nbsp%3B%20The%20fomula%20is%20looking%20for%20the%20year%20for%20the%20corresponding%20row%20in%20the%20fourth%20column%20(which%20should%20be%202017).%26nbsp%3B%20However%20there%20is%20an%20account%20number%20in%20the%20list%20which%20is%20not%20in%20the%20lookup%20table%20so%20I%20was%20expecting%20an%20error%20of%20some%20sort%20but%20it%20is%20also%20returning%202017%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughtys%20would%20be%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1119545%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi has any one had a problem with VLOOKUP NOT showing an error?

 

I want to identify the years associated with unique account numbers.  The account number is located in first column and is identified in the lookup formula.  It is searching the lookup table organised in ascending order with no duplicates (constant).  The fomula is looking for the year for the corresponding row in the fourth column (which should be 2017).  However there is an account number in the list which is not in the lookup table so I was expecting an error of some sort but it is also returning 2017?

 

Any thoughtys would be appreciated. 

1 Reply

Problem resolved please ignire this