Hi all, hope everybody is doing good.
I am working on a workflow - in one table I have lead ids, mql count and other details. In another table I have only lead Ids and mql count - 1(Legit ones).
I want to do a vlook up comparing the lead ids in both the tables and replace the mql count with mql count -1 for the particular dates (say for example from 3/1 to 4/1).
Please help me.
Thank you,
Sayeed
Solved! Go to Solution.
Hi @Sayeed1 ,
This is the way I would do it.
The join tool is working to replace all matches and leaving in L anchor all of those unmatched record.
Best,
Fernando Vizcaino
Thanks Fernando . I missed to mention the date column. This should happen only for particular dates say for example 6/1 to 6/10 and after that vlookup should stop for rest of the dates.
Please advise.
Hi @Sayeed1 ,
Would you be able to share a sample dataset?
Then I can adapt my solution to your exact problem.
Best,
Fernando Vizcaino
Hi @Sayeed1 ,
I've added a filter right before the join tool to make it work only with that range and then I use the union tool to unite everything once again.
Best,
Fernando Vizcaino
Thank you both - It worked 🙂 - Have a great day