free web stats

«

»

Dec 13

VLOOKUP Hack #8: Extra Spaces

When the lookup value has extra spaces, but the lookup range values don’t, VLOOKUP runs into problems. This leads us to our next hack. I’ve prepared a video and full write-up for reference. Let’s try to visualize the issue before we get to the hack.

Original source of full article