​

Assuming you have a data table and you want Excel to look up a certain value and return the same value in a different row. You need a search function for that. Excel has a number of functions that you can use to achieve this, including VLOOKUP and HLOOKUP.

​

HLOOKUP and VLOOKUP are functions in Microsoft Excel that allow you to use a portion of your spreadsheet as a search table. They are two of the most popular formulas in Excel, and using them together is one of the first formula combinations people learn.