Using VLOOKUP on Nested MID and SEARCH

Hello,

I have tried to find the answer elsewhere and it seems the issue I am having is regarding the formula outputting as text. I read that the "+0" at the end of something like the MID function will allow Vlookup to use it as a search word but I am not having any luck.

Here is the nested formula in A2:

Please Login or Register  to view this content.

lets say that formula returns "Lime Juice" then the below vlookup formula should be able to use output "Lime Juice" as its lookup:

Please Login or Register  to view this content.

Any ideas how to use vlookup to reference the output from the nested MID formula? Any help would be greatly appreciated.

Thank you, this worked. I didn't even think about a trailing space and assumed it must have been excel changing the format. Thank you for the assistance!