Forum Discussion
OPS-MLTSD
Post Patron
Post PatronLOOKVALUE does not return all fields
I have a table called ‘Employer-use this’, where I am trying use LOOKUPVALUE to return names of Region (Central East, Eastern etc), which is named as ‘Column’ right now (the last column on the pictur...
Hi OPS-MLTSD ,
Try to check the if these values come up using Power Query.
A good way to trouble shoot is using Merge queries option in Power Query
Also have a look at the blogs below.
https://exceloffthegrid.com/power-query-lookup-values-using-merge/
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Regards,
Harsh Nathani