Excel Magic Trick 1152

Formula or Power Query: Cost Report When Product IDs Don’t Match

DESCRIPTION

See how to create Total Cost Report when Product IDs in transaction table do NOT match Product IDs in Lookup Table:
(00:08) Set up of problem: Product IDs in transaction table do NOT match Product IDs in Lookup Table and we need to lookup costs to create a Total Cost Report
(00:56) Formula method with COUNTIF, Asterisk Wild Card and VLOOKUP
(03:26) Power Query




Be the first to comment

Leave a Reply