Excel Tips and Tricks for All Levels

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, [...]