Hi,
I'm trying figure out a way to use a vlookup function when the word in the
table is the same but indented differently. For instance, you're looking for
the price of an 'apple' but the word 'apple' in the table is actually written
' apple' with 4 spaces in front of the word.

I was trying to use the 'Right' function but the number of letters my vary.
Thanks for your inputs.