ISNA, ISERROR, and ISBLANK Formula in Excel
- Comments Off
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 […]
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, […]
VLookup in Excel
- Comments Off
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 ExcelHints.com. Once you learn how to use vlookup, it will greatly ease many of the pains you have had in […]