Lookup and reference

This page presents procedures from class WorksheetFunction related to the theme Lookup and reference

Lookup - Returns a value either from a one-row or one-column range or from an array. The Lookup function has two syntax forms: the vector form and the array form.

Match - Returns the relative position of an item in an array that matches a specified value in a specified order. Use Match instead of one of the Lookup functions when you need the position of an item in a range instead of the item itself.

Choose - Uses Arg1 as the index to return a value from the list of value arguments.

HLookup - Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row that you specify in the table or array. Use HLookup when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLookup when your comparison values are located in a column to the left of the data that you want to find.

Index - Returns a value or the reference to a value from within a table or range. There are two forms of the Index function: the array form and the reference form.

RTD - This method connects to a source to receive real-time data (RTD).

Transpose - Returns a vertical range of cells as a horizontal range, or vice versa. Transpose must be entered as an array formula in a range that has the same number of rows and columns, respectively, as an array has columns and rows. Use Transpose to shift the vertical and horizontal orientation of an array on a worksheet.

VLookup - Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.

XLookup -

XMatch -