Vlookup with Duplicate Entries

Using Vlookup to extract duplicate records with a twist
Click on the link below to learn Advanced Formulas , Pivot tables, Lookup formulas, VBA animation, Power BI, Power Query.

[rahulbehere]

I changed it a bit to adjust to my query but worked perfectly nice job.

[soilder]

Great Video, you have helped me solved what seemed to be impossible at first

[TheViperProductions]

I've been looking for this solution! Thank You!

[Behappy]

Hello sir. It was an excellent video. I have one doubt. What if I need vloopup on two separate sheet? I mean I need vlookup three values to an another sheet which has same values. The data is almost 70000 entries. Thanks!

[rajdhanraj]

Thank you for this help... How did you added drop down function at 06:05

[dikshant]

Why didn't i watch this before my interview 😢

[angelojayproductions]

How do we use ROW if the table is on another sheet?

[MrCharles]

Thank you very much sir.You really helped me but unfortunately I still have a small problem ., Why you wrote () row minus 1 ? you also higlithed "row' clicked F9., Ii couldn't see how it returned to
hank you very much

[kmash]

It was very informative but i need to know how can i get all the sales value of chris summed up in 1 row?

[rakhipatel]

Can you teach online excel formulas please

[prashantethape]

Short list ki beena bhi is formula nhi lg skta hai kyaa

[sandeepchauhan-dibf]

filter function can easily do same thing

[prashantethape]

Without drop down list ke formula kese aply kre

[alikodur]

How to skip to next column when sales column value contain 0