How to use lookup
function : VLOOKUP function in Excel
Excel Worksheet primarily supports
tabulation functions which are very useful for preparing reports and financial data. Inserting a formula in excel worksheet has
the following steps:-
Suppose a value to be
searched from one sheet and to be shown in another sheet vertical lookup(VLOOKUP)
function is used.
FORMULA =
VLOOKUP(A4,Sheet1!A1:F15,3,False).
In this formula when after
inserting '=' sign add the word/function name "VLOOKUP" inside the bracket the first item is
"A4". This is the lookup cell value. Then add the range
of cells "Sheet1!A1:F15" to look for this value out of the Range – A1:F15
and add the index number "3" out of which we want to take the
value. The value required is lies in the column index no.3. Finally for an exact match add “False”.
Comments
Post a Comment