xlookup to return a value with similar words

[FuNeS13]

So i have a list that looks something like this:

Title1
Data1 123
Data1 124
Data1 125
Data1 130
Data1 150
Data1 175

And I have a database that has, in some cases, the last one listed (Data1 175) or more than one listed.... I need all of the words that looks similar (in this case all of them) to return a value from my database... so the table would now look like this:


Title1
Data1 123 | Data1 175
Data1 124 | Data1 175
Data1 125 | Data1 175
Data1 130 | Data1 175
Data1 150 | Data1 175
Data1 175 | Data1 175

Has anyone done something like this before?

My original list is a list of software installed in all of the company's computers... so some of them have the same software but different versions... for example... Office 2010, Office 2013, Office 365... In my database I have Office 365 so I need all of the Office to show this Office 365 regardless of them being other versions.

Makes sense?

 

[GraH]

As a start, maybe this helps

Book1
	D	E	F	G
2	Data1 123		Data1 123	Data1 175
3	Data1 124		Data1 124	Data1 175
4	Data1 125		Data1 125	Data1 175
5	Data1 130		Data1 130	Data1 175
6	Data1 150		Data1 150	Data1 175
7	Data1 175		Data1 175	Data1 175
Sheet1

Cell Formulas
Range	Formula
G2:G7	G2	=XLOOKUP(LEFT(F2:F7,FIND(" ",F2:F7))&"*",D2:D7,D2:D7,,2,-1)
Dynamic array formulas.