Please go through the following blog to understand Vlookup function-
Apr 29 2014 07:15 PM
-- A macro is a small program designed to do a task.
-- Macro is basically used in Excel to automate a task that needs to be performed repeatedly.
-- A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.