Don’t be harsh on me of being so ignorant. But this concept is one thing which I never learned it quite right.
One of my colleagues, Nasir, used to teach me this wonderful VLOOKUP concept and I always got it wrong.
Today I decided to get it right once for all. Stumbled across this video, Brainstorm’s VLOOKUP Tutorial Video, which is available directly from MS Excel Help Links.
This is exactly what Nasir also explained me, but somehow I missed something in this entire process.
Thanks for his patience and thanks to this video. I thought I would create a pointer to this Easy to Understand Video, for those out there who are struggling (like me till today) to understand this concept.