Forum Discussion

Eric_Caldwell's avatar
Eric_Caldwell
Copper Contributor
Nov 06, 2022

VLookup not working. Hoping for new formula.

Hey! Hoping for some help with this vlookup formula. On "Master" Column c you can see the formula. Every time there is a new lead I input the details into the "meeting" tab - Jay, our lead generator is then put down next to all new meetings recorded. There is a pivot table that breaks down all the leads Jay has gotten for us, no matter how many orders they've made. I then use the Vlookup in Master sheet pulling from the pivot table. As you can see its pulling "Jay" as the sales rep even when he's not. For example "Henry me.com" should show up blank, given the email isnt in the VLOOKUP criteria, buts its pulling "Jay" as the sales rep for some reason. Any bit helps - Thanks! Google sheet linked below. 

 

https://docs.google.com/spreadsheets/d/1gjLvtEBmAlBCvM4y_UCU5FNYg0LKy3t42eakrHoywEk/edit?usp=sharing 

  • Eric_Caldwell 

    =IFERROR(VLOOKUP(A2,Meeting!$E$2:$F$7,2,0),"")

     

    You can try this formula in column C. The only difference is that this formula looks for an exact match because of the "0".

Resources