Mashup Code for VLOOKUP in Power Query

Power Query
1

I have a field in a lookup table that I want to bring into a fact table, is there Mashup Code for VLOOKUP in Power Query Editor? I want to avoid using ‘Combine Tables’.

2

@gareth.jones,

Merge is the VLOOKUP equivalent in Power Query. It can be done via UI or M code, but I’m not aware of an additional M function that will do the equivalent.

  • Brian
2 Likes
3

@gareth.jones

2 Likes
4

Thank you all for the support, I ended up finding the solution I was after by ‘Add Custom Column’, and with " = <table_name>" I inserted the table and was able to expand the table to introduce the fields needed as an exact match (replicating the vlookup).

2 Likes
5

Hi @gareth.jones, glad you were able to find the solution you are looking for. Thank you for sharing it with us too. We are marking this thread as “SOLVED”.

Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!