Excel Magic Trick 1356

Lookup 3 Items & Return to Single Cell Helper Column or Power Query?

DESCRIPTION

See how to lookup 3 Items & Return to Single Cell with a Cell Helper Column or Power Query:
(00:15) Introduction
(01:19) Cell Helper Column in Lookup Table solution. Trick thanks to Ian Putt At YouTube.
(02:50) Power Query (Get & Transform) solution with Merge Feature and Custom Column to Join items from Lookup Table.
(11:19) Summary

WORKBOOKS

Download “Excel-Magic-Trick-1341-1360.zip” Excel-Magic-Trick-1341-1360.zip – Downloaded 6828 times – 23 MB




Be the first to comment

Leave a Reply