Partners filmexxx.link, sextotal.net, ahmedxnxx.com, https://xnxx1xvideo.com, russianxnxx
Home

Vlookup Horizontally for Multiple Records

Posted on by Chandeep  -   

 Vlookup Horizontally for Multiple Records 11

One of our student, Akash sent me a problem. How would you solve it ? or in How many ways can you solve this ?

 

Assume 2 Sets of Data

Vlookup Horizontally for Multiple Records 2

 

Vlookup Horizontally for Multiple Records 3

  1. A list of all Gifts and Cost
  2. The gift options opted by client
  3. Your job is to find the total cost

 

DOWNLOAD THE PROBLEM

  • Your answer should be dynamic i.e. if the gift options change, so should their total
  • Put in your answers in the comments and of course brownie points for solving this using PowerQuery

 

.       

Automate repetitive data cleaning tasks using Power Query

A comprehensive course to learn Power Query to automate all your mundane and repetitive data cleaning tasks in Excel or in Power BI

 

DOWNLOAD THE COURSE OUTLINE    |    ENROLL IN THE COURSE

     


Topics that I write about...



Chandeep

Welcome to Goodly! My name is Chandeep. On this blog I actively share my learning on practical use of Excel and Power BI. There is a ton of stuff that I have written in the last few years. I am sure you'll like browsing around. Please drop me a comment, in case you are interested in my training / consulting services. Thanks for being around Chandeep