HLOOKUP and its Application

HLOOKUP and its Application HLOOKUP function performed it search horizontally by matching lookup value located at the first row (unlike VLOOKUP that is vertical) at the top to the row that holds the value you intend to return. It searched for either EXACT MATCH of the value you intend looking up in the table or[…]

Shares 0

VLOOKUP and its Application

VLOOKUP Function is one of the powerful Excel Formula that does a lot of magic for me. Interestingly, it enables me to carry out hundreds of calculations and analysis in minutes. Though the golden rule is to search vertically (top to bottom) of the left column (usually leftmost) of the lookup table until it established[…]

Shares 0

Using LEFT, MID and RIGHT for String Extraction

LEFT, MID and RIGTH functions are ideal tools to extract parts of text. LEFT function is used to extract the left-most characters, MID function is used to extract selected characters within text, and RIGHT function is used to extract right-most characters of a text in Excel. Let’s demonstrate how these functions work in the data[…]

Shares 0

INDIRECT Function

INDIRECT is used to create reference from text. More so, it can be use to generate random values. it returns reference to a range. Syntax: INDIRECT(ref_text[a1]) ref_text: a cell reference or text string that create the range reference. a1: this is said to be TRUE if the reference is using A1 reference style and FALSE[…]

Shares 0

Database Functions in Excel

This post is set aside to shed more light on database function use in Microsoft excel. Database is a detailed collection of data in such manner that can easily be read(access), manage, updated, and delete. In other word, a database can refer to as a list of related data in which rows of related information[…]

Shares 0

DATEDIF Function

DATEDIF function comes in handy to calculates the number of days, months, or years between two specific dates. Syntax: DATEDIF(Start_date, end_date, unit) Start_date: this represents the starting, or first, date of the period in question End_date: this indicates the end, or last, date of the period to determine the difference. Unit: indicates the type of[…]

Shares 0

VLOOKUP Function and Its Application

VLOOKUP Function This is one of the powerful Excel Formula that does a lot of magic for me. Interestingly, it enables me to carry out hundreds of calculations and analysis in minutes. Though the golden rule is to search vertically (top to bottom) of the left column (usually leftmost) of the lookup table until it[…]

Shares 0

IFERROR

This function helps to trap errors and return a meaningful values in place of usual cryptic error entry if formula evaluates to an error in Excel. Syntax: IFERROR(value, value_if_error) value: the expression to be check for an error value_if_error: value to return if error is found Let’s illustrate this an example below #DIV/0! and #VALUE![…]

Shares 0