VLOOKUP is a function in Excel that perform a vertical lookup by searching for a value in the first column of a table and returning for a value in the same row in the index number position.
VLOOKUP is simple, yet confusing for many.
I have tried to explain this function with help of very simple example in below You Tube video. Hope this will be helpful.
