Forum Discussion

Copper Contributor

Nov 25, 2017

vlookup not returning correct value

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.

Silver Contributor

Nov 25, 2017

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)

Copper Contributor

Nov 25, 2017

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