Forum Discussion
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.
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!
