NEVER need a VLOOKUP again! PowerPivot relationships are easier and faster to create in Excel. [ Ссылка ]
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.
