Perform a "VLOOKUP" in Power Query?

[rmcgrath]

I am trying to add a custom column in Power Query.  This column needs to take the value from "Line Item ID" (highlighted yellow) and go to a separate table called "RawGLData" and sum up the values from the "Net" column that refer to the value in Line Item ID.  For example, it would take "Cash" and sum up the "Net" values only for "Cash" from the "RawGLData" table.  If there is no value in the "Line Item ID", I would want it to remain blank ("")

[amitchandak · Accepted solution]

@rmcgrath , Merge the other table with the table and use the Aggregate option when you expand

Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo

You can also check - power Query Table.AddJoinColumn https://youtu.be/-mThmfSaiV8