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

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