Top 3 Most Read Articles This Week

20 February 2017 in Top 3
0 comments 2 minutes 441 views

Here are the 3 most read articles on our website over the last 7 days More...

Tags: , , , , , , ,

Microsoft Excel Functions: HLOOKUP

13 February 2017 in Formula, Powerful Formula
0 comments 2 minutes 1,080 views

HLOOKUP is the lesser used cousin of VLOOKUP, but can be just as useful. Learning how to use HLOOKUP can help in situations where VLOOKUP will not work More...

Tags: , , , ,

How To Use IFERROR

29 December 2016 in Formula, How To
0 comments 2 minutes 674 views

Do you get fed up when your formulas return #N/A when performing a VLOOKUP calculation? Learning to use =IFERROR can help solve that More...

Tags: , , ,

Powerful Excel Formula: INDEX MATCH

19 December 2016 in Powerful Formula
0 comments 3 minutes 744 views

In a previous article, we discussed the VLOOKUP formula and how one of its major flaws was that it will only search from left to right and adding new columns into your search array can break your... More...

Tags: , , , , , ,

Microsoft Excel Functions: VLOOKUP

21 October 2016 in Powerful Formula
0 comments 2 minutes 686 views

The VLOOKUP function is a fantastic function that can save you lots of time searching through data for values VLOOKUP searches for a value within an array and returns a corresponding value from a... More...

Tags: , ,