VLOOKUP: Search string longer than target string

[kophanz]

Hi,

Thank you in advance for the help!

In "Records" sheet, I have a list of units (Column A), and each unit has a corresponding score (Column B). In my actual document, there are 900+ units.

In Sheet2, I have some units for which I want to find the corresponding score. The problem is that the name captured on the "Records" sheet are shortforms, so they are shorter than the actual name, which is used in Sheet2. As a result, the normal VLOOKUP doesn't work for me. Is there a way to make it work?

[In the sample document, Sheet2 B2 should return '5', and Sheet2 B3 should return '7']

I hope this is clear. Thank you very much!