Spreasd sheet Application
A worksheet with Rows and Co
Cell: Rectangular box
Row: A group of cells in a horzo
Column: A group of cells in verti
Spreadsheet Application:
Data storage in Organised way
Spreadsheet Application:
Data storage in Organised way
Simple to Complex Calculation
Data analysis & Reports
Data entry
Accounting
Application
th Rows and Columns
box
cells in a horzontal line
of cells in vertical line
cation:
ganised way
cation:
ganised way
x Calculation
eports
The VLOOKUP formula in Excel is a powerful
function that allows you to search for a value
table and return a corresponding value from
another column.
The syntax for the VLOOKUP formula is:
VLOOKUP(lookup_value, table_array, col_index_num, [range_loo
Here's what each argument means:
1. lookup_value: The value you want to search for in the table.
2. table_array: The range of cells that contains the table you want
search.
3. col_index_num: The column number that contains the value yo
to return.
4. [range_lookup]: [Optional] A logical value that specifies whethe
want an exact match (FALSE) or an approximate match (TRUE).
l is a powerful
arch for a value in a
ing value from
dex_num, [range_lookup])
ch for in the table.
ns the table you want to
contains the value you want
that specifies whether you
ate match (TRUE).
Formula Structure
= Values + Calculation operators + Brackets+ Function
Brackets
[] Square brackets
{} Curly braces
() Parenthesis
Calculation operators
Arthmetic
+ plus
- minus
* Asterisk
/ ForwardSlash
% Percentage
^ Caret
Comparsion
> Greater than
< Lesser than
>= Greater than or Equal to
<= Lesser than or Equal to
= Equal
<> Not Equals
Text
& Ampersand
Referencwes
: Colon
, Comma
Space
The HLOOKUP formula in Excel is sim
VLOOKUP formula, but instead of sea
value in a column, it searches for a v
The syntax for the HLOOKUP formula is:
HLOOKUP(lookup_value, table_array, row_
[range_lookup])
Here's what each argument means:
1. lookup_value: The value you want to search for in t
2. table_array: The range of cells that contains the tab
search.
3. row_index_num: The row number that contains the
to return.
4. [range_lookup]: [Optional] A logical value that spec
want an exact match (FALSE) or an approximate matc
to return.
4. [range_lookup]: [Optional] A logical value that spec
want an exact match (FALSE) or an approximate matc
The main difference between HLOOKU
the direction of the search:-
VLOOKUP searches for a value in a co
value from a corresponding row.
- HLOOKUP searches for a value in a ro
value from a corresponding column.
n Excel is similar to the
instead of searching for a
arches for a value in a row
P formula is:
ble_array, row_index_num,
nt to search for in the table.
hat contains the table you want to
er that contains the value you want
ical value that specifies whether you
approximate match (TRUE).
ical value that specifies whether you
approximate match (TRUE).
etween HLOOKUP and VLOOKUP is
arch:-
r a value in a column and returns a
nding row.
or a value in a row and returns a
nding column.
