Home > Excel Help Portal > Doing Lookups in Excel

<<  (Page 1)  Previous              Next  (Page 1)  >>

Doing Lookups in Excel

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses using lookups in
Microsoft Excel formulas.

1. Insert Rows using a Macro
2. Summarizing Data Examples (an Overview)
3. VLOOKUP Worksheet Function
4. How to Select Cells/Ranges Using Visual Basic Procedures in Excel
5. SNAKECOLS, How to snake columns to use fewer pages
6. Overview of Excel 2002 SP2 Update: October 16, 2002
7. Build TOC Another Approach
8. How to use the Excel Lookup Wizard (Lookup.xla) in Excel 2000
9. Validate / Validation
10. Excel Filters -- Advanced Filter
11. How to Use the LOOKUP Function
12. How to AutoFilter Records Based on Cell Formatting
13. Excel -- Data Validation -- AdvancedTechniques
14. Excel -- Data Validation -- Dependent Lists
15. How to autoFilter Records Based on Cell Formatting in Excel 2000
16. Index and Match instead of VLOOKUP?
17. How to perform a TwoDimensional Lookup in Excel 2000
18. How to rank Duplicate Values Sequentially in Excel 2000
19. How to Rank Duplicate Values Sequentially
20. How to Perform a CaseSensitive Lookup
21. Performing a Lookup with Unsorted Data in Excel
22. How to Use the VLOOKUP Function
23. How to eliminate redundant data in an Excel list
24. How to Use INDEX and MATCH Worksheet Functions with Multiple Criteria
25. Excel drop down lists
26. Random Numbers
27. Excel Filters -- AutoFilter Basics
28. How to Use the INDIRECT Function to Create References
29. Excel -- Data Validation -- Hide Previous Selections
30. Help using Excel spreadsheet functions - vlookup, isna, match
31. Calculation Problems When Custom Function Creates a Defined Name
32. Excel -- Data Validation -- Use List from Another Workbook
33. How to Return the First or Last Match in an Array
34. Changing Cell References
35. How to create a Link to a Worksheet within an Excel WorkBook in FrontPage 2000
36. Help using Excel spreadsheet functions - Offset, Choose
37. Excel -- Pivot Tables -- Dynamic Data Source
38. Excel -- Pivot Tables -- Grouping Data
39. Miscellaneous Code fragments of Worksheet functions
40. Perform two-way table lookups
41. Make a Drop Down List
42. How to calculate and display the largest value
43. Use Index and Match to lookup a cell to the left of your key cell
44. Excel -- Named Ranges
45. Alternate row shading using Conditional Formatting

<< (Page 1)  Previous              Next  (Page 1) >>