Lookup Formulas Tips - All Tips (58 tips)
- 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
- Advanced VLOOKUP
»Click here to submit a tip to Lookup Formulas tips
