 |
|
|
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
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel
| MSSQL Migration
Toolkit |
Monte Carlo Add-in |
Excel
Costing Templates