PowerPivot Relationships are EASIER than VLOOKUP, not just faster
Raw Data with Rob Collie
0:00 / 0:00
PowerPivot Relationships are EASIER than VLOOKUP, not just faster
196 953 просмотра · 13 лет назад
Raw Data with Rob Collie
15,5 тыс. подписчиков
196 953 просмотра · 13 лет назад
NEVER need a VLOOKUP again! PowerPivot relationships are easier and faster to create in Excel. http://www.PowerPivotPro.com
VLOOKUP is used for merging or blending two tables of data in Excel. It's the original mashup tool! But it's a scary function with arguments like "lookup_value" and "table_array" and my personal favorite "[range_lookup]" which really should be named "[always_set_me_to_FALSE]".
It turns out that VLOOKUP is harder for some people to use than pivots themselves! I've long viewed PowerPivot's relationships capability as a far superior alternative to VLOOKUP, but purely from a speed and elegance standpoint.
It turns out that PowerPivot is also a much friendlier and more approachable alternative as well.