Vlookup in excel

[Sayeed1]

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

[fmvizcaino]

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

[Sayeed1]

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.

[fmvizcaino]

Hi @Sayeed1 ,

Would you be able to share a sample dataset?

Then I can adapt my solution to your exact problem.

Best,

Fernando Vizcaino

[Sayeed1]

Please check this

[fmvizcaino · Accepted solution]

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

[deviseetharaman]

Hi @Sayeed1 

Please a filter before the join and add it back using a union tool.

[Sayeed1]

Thank you both - It worked 🙂 - Have a great day