Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.

How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

You can use the following methods to compare data in two Microsoft Excel worksheet columns and find duplicate entries.

Look up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned. Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and …

You can create a relationship between two tables of data, based on matching data in each table. Then you can create Power View sheets and build PivotTables and other reports with fields from each …

This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result.

With the cells still selected, go to the Data tab, then from Data Types, select Geography. If Excel finds a match between the text in the cells, and our online sources, it will convert your text to the Geography …

One of the most powerful features in Power Pivot is the ability to create relationships between tables and then use the related tables to lookup or filter related data. You retrieve related values from tables by …

To summarize and report results from separate worksheets, you can consolidate data from each into a master worksheet. The worksheets can be in the same workbook as the master worksheet or in …