Look things up
Look up using part of a word
=XLOOKUP("*"&E2&"*",A2:A5,B2:B5,"Not found",2)How it works in Excel
- The * signs mean "anything can be here".
- 2 turns on this kind of matching.
- It returns the first match it finds.
- It needs Excel 2021 or Microsoft 365.
The idea in general
You search for a piece of the name instead of all of it.
What I assumed
- The list is in A2:A5, the values are in B2:B5 and the partial word is in E2.
Check the result on your own data before relying on it.