Improve Your Excel.com Everything you need to improve your Excel in one place! Home Categories Tips By Email Search Contact Us Other Links Your Questions Answered

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

Want more tips? Subscribe to our Free Newsletter today and we will send them to you.

Most Popular Categories |Bar_Charts |Charts |Pie_Charts |Excel Counting |Excel Filters |Pivot_Tables |Excel_Keyboard_Shortcuts |Conditional_Formating |VLookup |Games |Names_and_ranges |VBA_Examples |Macros

website stats online web site counter