Skip to content

Dear Internet Explorer user: Your browser is no longer supported

Please switch to a modern browser such as Microsoft Edge, Mozilla Firefox or Google Chrome to view this website's content.

INDEX MATCH instead of VLOOKUP

Posted 22nd January 2015

1 comment

INDEX MATCH represents a much better way to search for data in Excel tables than VLOOKUP because this combination is much more versatile.

Read the full story...

VLOOKUP in Excel with multiple criteria

Posted 3rd December 2014

No comments

An alternative to VLOOKUP in Excel that permits a search based on multiple criteria.

Read the full story...

Sum of Column B, based on values in Column A

Posted 28th November 2014

No comments

Use an array formula to calculate selected values in one column, based on parameters in another.

Read the full story...

Open and close Excel workbooks in the background

Posted 4th September 2014

2 comments

Use a Visual Basic for Applications (VBA) script to open secondary Excel workbooks as data sources when opening a VLOOKUP-dependent workbook.

Read the full story...

Round to the nearest work day in Excel

Posted 31st July 2014

No comments

Use this basic formula to round any scheduled date to the next working day (Monday to Friday) for use in workplace task planning.

Read the full story...

Automatically update Pivot Tables in Excel

Posted 15th July 2014

No comments

A simple VBA script that refreshes (updates) all Pivot Tables within an Excel workbook after any change to a worksheet.

Read the full story...

Add a suffix to selected cells in Excel

Posted 12th July 2014

2 comments

Use this handly VBA macro to automatically add characters to the end of values in a selected range of cells.

Read the full story...

Automatically number rows in Excel

Posted 16th January 2014

No comments

Use a simple Visual Basic for Applications (VBA) script to automate the process of numbering new rows in Microsoft Excel.

Read the full story...

Blog post thumnail

How to enable the Data Analysis toolpak in Excel 2010

Posted 15th February 2013

2 comments

Instructions for adding the Data Analysis tool pack to Microsoft Excel

Read the full story...