Перейти к содержимому

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.