Vlookup in excel

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

Accepted answers

fmvizcaino

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

2020-06-10 Vlookup in excel.yxmd

All comments

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

2020-06-10 Vlookup in excel.yxmd

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

sample.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703