 |
| FREE Excel STUFF |
Search |
| Excel Help. Popular |
| NEW! Multiple Excel Search & Links |
| Excel Formulas |
| Excel Macros |
| Excel Newsletter |
| PRODUCTS |
| Up to $139.00 FREE! |
|
Categories & Search |
| Excel Templates |
| Excel Add-ins |
| Excel Training |
| More.... |
| OTHER |
| Excel Development |
|
|
NEW! More Books.. |
Add Excel Answers & Search To Your Google Toolbar Details |
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
