Nov 24 2017 09:40 PM
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.
Nov 24 2017 10:16 PM
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)
Nov 24 2017 10:27 PM
Thanks for being so generous with your time to help others! This worked and I'm so thankful for your help!