HLOOKUP Whenever anyone thinks about a lookup function, the first thought is typically Vlookup . Sometimes however a Hlookup will do the t...

  Go To Special feature can be very useful in a variety of ways. Many of the selections are pretty self explanatory. For instance, you can...

I love to use Data Validation to create dropdown lists  - particularly when working with Vlookups but I found it irritating that my source ...

Table of Contents When you think of Table of Contents , you immediately think of  Microsoft Word but it can also be useful in Excel. I th...

As I mentioned the other day,  SUMPRODUCT is very powerful. If you looked at the earlier blog, you saw its original or basic use -Multiplyi...