vlookup not returning correct value

Copper 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

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)

 

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