Tutorials: Lookup and Search Functions in Excel
Excel Lookup/Search Tip 1 - Using Index and Match - It's Better than Vlookup (Intermediate)
- Learn how to use the Index and Match lookup functions in Microsoft Excel. They
- Learn how to use the Index and Match lookup functions in Microsoft Excel. They
Excel Lookup/Search Tip 2 - Vlookup Explanation 1 - Display Product Suppliers from a List/Database (Easy)
- Learn how to use the VLOOKUP() function in Microsoft Excel. This tutorial will
- Learn how to use the VLOOKUP() function in Microsoft Excel. This tutorial will
Excel Lookup/Search Tip 3 - Vlookup Explanation 2 - Vlookup to Search an Employee Database (Intermediate)
- Learn how to use the VLOOKUP() function in Microsoft Excel in the second walk-th
- Learn how to use the VLOOKUP() function in Microsoft Excel in the second walk-th
Excel Lookup/Search Tip 4 - Vlookup Explanation 3 - Vlookup to Assign Grades to Students (Intermediate)
- Traditional VLOOKUP() function example in Excel. This tutorial teaches you how
- Traditional VLOOKUP() function example in Excel. This tutorial teaches you how
Excel Lookup/Search Tip 5 - Vlookup - IFERROR with Vlookup to Assign Values Instead of Errors (Easy)
- Use the new IFERROR() function in Excel 2007 in conjunction with the VLOOKUP() f
- Use the new IFERROR() function in Excel 2007 in conjunction with the VLOOKUP() f
Excel Lookup/Search Tip 6 - Vlookup with a Drop Down Menu and Data Validation (Intermediate)
- Learn how to use the VLOOKUP function in Excel in conjunction with a data valida
- Learn how to use the VLOOKUP function in Excel in conjunction with a data valida
Excel Lookup/Search Tip 7 - Vlookup on Data that has a Prefix before it (Intermediate)
- Learn how to use the VLOOKUP function in Excel to search a database or table arr
- Learn how to use the VLOOKUP function in Excel to search a database or table arr
Excel Lookup & Search Tip 8 - Vlookup with Lookup Values that Have Extra Values in the Cell in Excel (Intermediate)
- This Excel Video Tutorial shows you how to use the VLOOKUP() function with looku
- This Excel Video Tutorial shows you how to use the VLOOKUP() function with looku
Excel Lookup & Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel (Intermediate)
- This Excel Video Tutorial will show you how to use the VLOOKUP() function in Exc
- This Excel Video Tutorial will show you how to use the VLOOKUP() function in Exc