I have two columns, Emp ID (Number) and their corresponding manager ID "Manager" (Number) and would like to add 3rd column "Type" to determine who is Individual Contributor (Not Manager) and who is Manager. In excel I use Vlookup but
don't see such function in Power Query. Can anyone help me with easiest solution?