Date Formulas in Excel
Some of the more common formulas I use on a regular basis are date manuputation formulas. Whether it using the Date() formula or the Month() formula or many others, there are several ways to show data that have dates involved. Let’s start by taking a look at the Date Formula itself: Date(Year, Month, Day) where [...]
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
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 [...]
Loading ...