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.
Who Should Attend?
This event is intended for finance, sales, data analysts, marketers and anyone interested.