 |
|
|
Current Special!
Complete Excel
Excel Training Course for Excel 97 - Excel 2003, only $145.00.
$59.95 Instant
Buy/Download, 30 Day Money Back Guarantee
& Free Excel Help for LIFE!
VLOOKUP
Syntax: =VLOOKUP(lookup_value,table_array,col_index_num,optionalrange_lookup)
=======================================================================
HLOOKUP
Syntax: =HLOOKUP(lookup_value,table_array,row_index_num,optionalrange_lookup)
========================================================================
INDEX/MATCH Lookup data in any column of a table and return the corresponding data to the left or right.
========================================================================
Lookup any
Occurrence Lookup data in any column of a table and return the corresponding data to the left or right.
Sliding Scale Lookup
Lookup Table
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS