Nov 06 2022 12:40 PM - edited Nov 06 2022 12:41 PM
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
Nov 06 2022 12:56 PM
=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".