Hi all,

I'm having trouble with an index match formula. My lookup values look like one of these two types:

092GSW015
103P 345

Whenever the formula hits the second value (with the space in the middle) it returns #N/A. I've spent a lot of time trying to figure out how to fix or use a different formula, but so far have had no luck. So now hoping someone smarter than me (not hard!), can help.

Any suggestions?


Note user level = beginner