EASY-to-follow EXCEL TUTORIALS
-
Excel VLOOKUP Function: How it works
How does the Excel VLOOKUP function work?
In the previous post (about LOOKUP function), I mentioned VLOOKUP but did not really go into details. I’ll go into details this time but I’ll make this VLOOKUP tutorial quick and simple yet understandable.
The V in VLOOKUP stands for vertical—not value! It searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. The syntax for this function is VLOOKUP(lookup_value,table_array,col_index_num,range_lookup).
continue reading Excel VLOOKUP Function: How it works
-
Excel LOOKUP Function
In Excel, the LOOKUP function returns a value from a range (one row or one column) or from an array. The LOOKUP function has 2 different syntaxes, namely: vector and array
The LOOKUP vector syntax is Lookup(lookup_value,lookup_vector,result_vector). This form of LOOKUP looks in a one-row or one-column range for a value,then returns a value from the same position in a second one-row or one-column range.
-
The Most Basic: WHAT IS EXCEL?
You may think asking the question “WHAT IS EXCEL?” is pretty stupid. But think again. Even those who have been using this Microsoft spreadsheet application and acquired a doctorate degree in dealing with excel formula and functions, pivot tables and VBA (Visual Basic for Application) aka macro can’t give a brief yet concise description of EXCEL. I’m not generalizing but most just really can’t!
Question: What is Excel?
