Changing VLOOKUP with the information Model and Relationships

March 07, 2018 - by Bill Jelen

Don't possess Power Pivot? Does Not Matter. Nearly all of energy Pivot is created directly into Excel 2013 and many more in succeed 2016. Today, our tip from Ash is joining tables in a pivot dining table.

Every Wednesday for seven months, i'm featuring one of several favorite guidelines from Ash Sharma. Ash is an item supervisor regarding the succeed group. Their group brings you pivot tables and several other good stuff. Today, Ash's favorite function is joining numerous information sets utilizing Relationships together with information Model.

Say that your particular I.T. department provides you with the information set shown in columns A:D. You can find areas for consumer and market. You'll want to combine particular areas into areas. Each consumer belongs to a sector. Region and Sector aren't within the initial information, you have lookup tables to produce these details. (more…)