Conditional Functions G11

Data type functions used to returns TRUE if a value is a number

• ISNUMBER( )

• ISTEXT( )

• ISERROR( )

Data type functions used to returns TRUE if a value is a text

• ISTEXT( )

• ISNONTEXT( )

• ISNUMBER( )

Function will look up a value in a table and return another value in the same row or column

• Power Function

• Lookup functions

• Index function

Function used to look for a value in a column and return a value from the same row

• Vlookup

• Hlookup

Function used to look for a value in a row and return a value from the same column

• Hlookup

• Vlookup

Function will be find a value based on it is position within a table.

• MATCH FUNCTION

• INDEX FUNCTION

• POWER FUNCTION

Is one which can include more than one function or formula

• Lookup functions

• Nested formulas and functions

In VLOOKUP function, If we want the exact value , we should add....

• TRUE

• FALSE

= .........................(Search Value, Lookup Table , Column, Match)

• Vlookup

• Hlookup