=vlookup in formatted text

I am trying to return a value from a =vlookup where the array has some lines with spaces. It is easy the other way using trim. I've attached a sample.

Thanks

I usually would clean up the data but it is an automated dump from MSP with numerous different indents.

You solution is exactly what I needed. Thank you.