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

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI