Index Formula vs. Vlookup Formula Vlookup Formula – Eliminating Errors Combine the VLookup and Match formulas in Microsoft Excel Combine the Index and Match formulas in Microsoft Excel Vlookup Formula – Organizing the Data Table Retrieve information from a range in another Excel File when the Path & File Name strings stored in various cells. Use VLOOKUP Function as an alternative to a number of nested IF functions. Using VLOOKUP and ISNA functions to find matching values in different sheets Avoiding the Occurrence of Unexpected VLOOKUP #N/A Errors Retrieving a Price Value By Looking at Two Difference Data Tables Altering the results returned by VLOOKUP. Retrieving an Item from a List that Meets Multiple Criteria Retrieving A Value From A Reference Grid, Using Indexes Listed In Another Range Retrieving Sale Price Based On Item And Color Criteria Retrieving Values Using Range Names as References Retrieving Values Using References Based on Row and Column Numbers Retrieving Each Second Number from Two Lists Retrieving Values Using Range Names as References Retrieving Values Using Range Names as References Retrieving Values from Different Sheets Using the Sheet Name as a Reference Retrieving Values from another Sheet Using Date as Sheet Name Reference Retrieving a Specific Cell from Multiple Sheets Retrieving Values from another Excel Workbook Using Text References Retrieving the Price for a Specified Item and a Specified Brand Retrieving from List by Position Ranking Salespeople According to Sales Figure Retrieving the Player Who Scored the Highest Number of Points Retrieving File Name by Matching a Given Page Number in a Book Retrieving Grade Value for Corresponding Mark Retrieving the Most Frequent Occurrence for Each Category Retrieving the Last Value and the Last Character in a Row Retrieving the Last Value in a Dynamic List Retrieving the Value of the First Non-Blank Cell in a List Retrieving the Most Recent Payment Made by Client Retrieving the Closest Larger / Closest Smaller Values from a List when there is No Exact Match Retrieving the First Value in a List that is Greater / Smaller than a Specified Number Finding the Maximal / Minimal String, Based on Alphabetic Order Retrieve Value Using Case-Sensitive Lookups Retrieving the Minimal / Maximal Values from a Filtered List Retrieving Smallest Nth Value Match Within a List Finding Every Third Number and Returning the Largest of Them Retrieving the Nth Value in a Row / Column Retrieving Every Nth Value in a Range Retrieve the Distance between Any Two Cities from Distance Table Retrieving Matching Values From Not Adjacent List Retrieving an Item from a List that Meets Multiple Criteria Retrieving an Item from a List that Meets Multiple Criteria Retrieving Sale Price Based on Item and Color Criteria Retrieving a Price from a List that Matches both Category and Item Criteria Retrieving the Entire Row of a Matched Value Returning the Entire Contents of the Row Containing the Highest Math Grade Retrieving a Price Value by Looking at Two Difference Data Tables Retrieving the Column Header of the Next Non-Blank Cell in a Row Finding the First Value in a Row and Retrieving the Header for That Column Retrieving the Column Header that Corresponds with a Matched Value Retrieving the Column Header of the Largest Value in a Row Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range
Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation
Site Developed By: Irubin Consulting