![]() A range that contains only one row or one column. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value. A value that LOOKUP searches for in the first vector. The LOOKUP function vector form syntax has the following arguments: The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range. To use the array form, your data must be sorted. For example, if you want to search columns A and B, down to row 6. The array form is provided for compatibility with other spreadsheet programs, but it's functionality is limited.Īn array is a collection of values in rows and columns (like a table) that you want to search. For example, if you want to search for a value in column A, down to row 6.Īrray form: We strongly recommend using VLOOKUP or HLOOKUP instead of the array form. Use the vector form when you want to specify the range that contains the values that you want to match. Vector form: Use this form of LOOKUP to search one row or one column for a value. There are two ways to use LOOKUP: Vector form and Array form If you are using Microsoft 365, use XLOOKUP - it's not only faster, it also lets you search in any direction (up, down, left, right). ![]() ![]() Watch this video about how to use VLOOKUP. Use VLOOKUP to search one row or column, or to search multiple rows and columns (like a table). Tips: Consider one of the newer lookup functions, depending on which version you are using. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |