Vlookup with only partial text match

Hi and welcome to the forum

You could use wild cards to look up data either way, but it will be easier to use the data in the 2nd data set (IF thats the 1 thats always shorter), and then find that in the 1st data set. Assuming your data is in A1 and B1 ($XX), use something like this...

=iferror(vlookup(A1&"*",data_set1!$A$1:$B$100,2,0),"Not Found")

This will return the value in column B for all matches based on what you have in data set 2. the iferror() will return "Not Found" if there is no match