May 30 2007

ISNA, ISERROR, and ISBLANK Formula in Excel

Excel has many built-in formulas that will check for errors for you. Were going to take a look at three of those formulas, which are ISNA, ISBLANK and ISERROR. Let’s start by taking a look at the formulas: ISNA(value) ISERROR(value) ISBLANK(value) Each of these formulas looks at value and evaluatues whether it is #N/A (with […]

Apr 23 2007

HLookup in Excel

I thought a good next post would to add how to use HLookup after posting the VLookup information last time. The two functions are very similar only they do the opposite things with it comes to looking a against a table. Let’s start by taking a look at the formula for HLookup: HLookup(lookup_value, table_array, row_index_num, […]

Apr 20 2007

VLookup in Excel

The Vlookup Function is a part of Excel that I personally use everyday. So many Excel users have no idea it even exists, so I thought this would be a great place to start for Once you learn how to use vlookup, it will greatly ease many of the pains you have had in […]

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks