HLOOKUP function
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Lookup values by column in a horizontal table or range

=HLOOKUP (lookup_value, table_array, row_index_num, [range_lookup])


Clustered Column chart
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Plots data in vertical columns by category.

Make comparisons between discrete categories.

2D and 3D options are available.


LOOKUP function
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Search one row or one column (or an array) for a value

(Vector form) =LOOKUP (lookup_value, lookup_vector, [result_vector])

(Array form) =LOOKUP(lookup_value, array)


Stacked Column chart
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Plots data in vertical columns stacked by category.

Emphasizes the total of two or more data series over time.

2D and 3D options are available.


TRIM function
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Remove irregular spacing from either end of or within a text string.

TRIM(text)


MODE.MULT function
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Returns a vertical array of the most common values in a data set.

=MODE.MULT(number1, [number2], ...)


Surface chart
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Resembles a topographic map with colors and patterns representing similar values.

Useful for spotting optimum combinations between 2 sets of data.

3D, Wireframe 3D, Contour and Wireframe Contour versions exist.


ISNONTEXT function
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Return the logical value TRUE if the cell contains any value that is not text.

=ISNONTEXT(value)


CONCAT function
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Join two or more text strings together.

CONCAT(text1, [text2], …)


ISLOGICAL function
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Return the logical value TRUE if the cell contains either a TRUE or FALSE statement.

=ISLOGICAL(value)


INDEX function
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Return the value or reference of specified cell(s)

Array form: =INDEX(array, row_num, [column_num])

Reference form: =INDEX(reference, row_num, [column_num], [area_num])


MID function
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Extract characters from within a text string.

MID(text, start_num, num_chars), MIDB(text, start_num, num_bytes)


Register (for free!) or Login to access bonus materials

About xlsnippets

Learn how to master functions, charts, pivot tables and more using Excel for Microsoft Office 365. Simple instructions and embedded spreadsheets help you practise the basics.

Latest Updates

26 March 2022
26 March 2022
26 March 2022
25 March 2022
22 March 2022

Coming soon

xlsnippets.com is currently in beta version. More functions and bonus content for registered users will be added weekly. Detailed training courses with additional downloadable resources are also on the horizon!