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, range_lookup)
lookup_value is [...]

Excel Contest
XLAutomation
Easily design MySQL databases as familiar spreadsheets in Micros
Get Expert Excel Help Today! 714.262.6893
Get Expert Excel Help Today! 714.262.6893

Categories

Excel Poll of the Week

How often do you use Excel macros (VBA)?

View Results

Loading ... Loading ...

Category Cloud

Add Comments Column Headers Concatenate Contest Count CountA CountBlank CountIf Date Drop Down Menu Excel Forum Excel Info Excel Macros Excel Version Formatting HLookup Hyperlink ISBLANK ISERROR ISNA Keyboard Shortcuts Large Left Length Loan Payment Calc Loops Match Mid Protection Rank Record a Macro Right Select Whole Sheet Site Updates Small Status Bar Messages Substitute SumIf Today Trim VLookup

Most Viewed