vlookup in power query

[charliec]

hi, i am trying to find what the syntax is for the vlookup function in power query? i want to add a custom column to a table where the new column looks up an employee id and returns the name that is in another column. in regular excel it would be vlookup(a1,a:e,3,0). thx

[alansidman]

You would use the combine functionality to join two tables with an outer join.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[charliec]

thanks. i think i found a way around it to give similar results.

[alansidman]

Care to share your solution so that it may help others

[charliec]

it wasn't a real solution. i just imorted the data into a table and added helper columns with the lookups i needed. when i have more time i may try to do it the right way.

[alansidman]

If you had provided sample data, then I would have been happy to show you how in PQ.