Home

vlookup not returning correct value

%3CLINGO-SUB%20id%3D%22lingo-sub-131188%22%20slang%3D%22en-US%22%3Evlookup%20not%20returning%20correct%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131188%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENovice%20with%20Vlookup%20-%20I%20really%20thought%20I%20had%20this%20but%20this%20formula%20keeps%20producing%20the%20wrong%20value.%26nbsp%3B%20What%20am%20I%20doing%20wrong%3F%26nbsp%3B%20Thanks%20so%20much.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-131188%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131192%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%20not%20returning%20correct%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131192%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20being%20so%20generous%20with%20your%20time%20to%20help%20others!%26nbsp%3B%20This%20worked%20and%20I'm%20so%20thankful%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131191%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%20not%20returning%20correct%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131191%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20the%20match%20method%20in%20VLOOKUP%20to%20exact%20match%20as%20follows%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EReplace%20this%3A%3C%2FP%3E%0A%3CPRE%3E%3DVLOOKUP(A2%2C'Complete%20source'!A2%3AH7%2C7)%3C%2FPRE%3E%0A%3CP%3EWith%20this%3A%3C%2FP%3E%0A%3CPRE%3E%3DVLOOKUP(A2%2C'Complete%20source'!%24A%242%3A%24H%247%2C7%2CFALSE)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

 

Novice with Vlookup - I really thought I had this but this formula keeps producing the wrong value.  What am I doing wrong?  Thanks so much.

 

2 Replies
Highlighted

Hi,

 

Change the match method in VLOOKUP to exact match as follows:

 

Replace this:

=VLOOKUP(A2,'Complete source'!A2:H7,7)

With this:

=VLOOKUP(A2,'Complete source'!$A$2:$H$7,7,FALSE)

 

Highlighted

Thanks for being so generous with your time to help others!  This worked and I'm so thankful for your help!