How to do a VLOOKUP in Microsoft Excel
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.