Helping solving Vlookup, Match/Index failure

[hellfire45]

Would anybody be willing to take a look at an excel file I've got that has a VLookup and Match/index returning both #N/A? I've tried searching on the web for solutions but everything I've found so far as failed.

I can email the file out. I'm sure for somebody who is more skilled this is an easy fix but I seem to always have continuous problems with these formulae.

Thank you!

 

[AlphaFrog]

Put this in F2 to remove the trailing space from the QB name.
=TRIM(LEFT(A2,E2-1))

Or this
=LEFT(A2,E2-2)

 

[hellfire45]

Thank you. There was a space hiding in one of my columns. Problem solved. Much MUCH appreciated.