VLookup not working. Hoping for new formula.

Copper Contributor

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 

1 Reply

@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".