Vlookup/Lookup Value in Query Editor/M Language

Hello,

Is there a way to do a vlookup/lookup value calculation in the query editor using M Language?  I believe the Merge function is one way to acheive this.  However in my dataset that I am trying to bring data into contains duplicates.  The dataset I am looking the data up in also contains duplicates so I get an error with the Merge.  Generally speaking I understand I shouldn't have duplicates in both data sets however the value I am trying to retreive via vlookup/lookup value is the same regardless of the duplicate values.  I cannot group or otherwise parse my query dataset down to exclude duplicates because I need this data for other visuals in my model.  I could create another query I realize but then I have to make the data sets related in order to make my already complex model function correctly so I belive the lookup value is the easiest.  I understand I can do this in DAX but I wanted to know if I could do it in the Query Editor also.

Thanks in advance!