For the VLOOKUP or HLOOKUP function, the lookup_value can be:

Question

BlackTom AI · Accepted Answer

When considering what the lookup_value argument can be in VLOOKUP or HLOOKUP, several possibilities are allowed by Excel's functions and help documentation.
Option: 'text' — This is valid. A lookup_value can be a text string that matches a text entry in the first column (for VLOOKUP) or first row (for HLOOKUP) of the lookup range.
Option: 'a name or reference that refers to a value' — This is also valid. You can use a named range or a cell reference as the lookup_value, as long as its evaluated value matches something in the lookup array or row.
Option: 'any of these choices' — This option is itself a statement about all permissible types, and given the other options are valid, this is a plausible encompassing choice.
Option: 'a logical value' — This is valid too. A TRUE/FALSE value can be used as a lookup_value and will match corresponding boolean entries in the lookup array.
Option: 'a number' — This is valid as well. Numeric lookup_values are commonly used to locate a numeric entry in the first column (VLOOKUP) or first row (HLOOKUP).
The underlying concept is that lookup_value is the value you want to locate within the lookup table, and Excel accepts text, numbers, logicals, and references that produce these types, as long as there is a corresponding match in the lookup range. Each of the non-encompassing options represents one of the valid data types that could serve as a lookup_value in practical scenarios.
Keep in mind that the exact matching behavior depends on whether you use an exact match (range_lookup set to FALSE) or an approximate match (TRUE or omitted), and on the structure of your lookup_table. If a provided lookup_value has the same data type and, when necessary, aligns with the data type in the lookup area, a match can be found.

For the VLOOKUP or HLOOKUP function, the lookup_value can be:单项选择题

类似问题

The only difference between a VLookup and HLookup table is that:

On the VLOOKUP_HLOOKUP tab using LOOKUP assignment.xlsx, what value does the HLOOKUP formula return for the GOOD scenario (cell B27) ANSWER FORMAT = x.xx NOT x% DO NOT WORRY IF CARMEN ADDS ZEROS AFTER YOUR ANSWER

The table_array argument in the VLOOKUP or HLOOKUP function should include any row or column headings.

What was the world's first widely adopted biodiversity policy?

The aim of the Paris Agreement is to ensure that the earth’s preindustrial temperature is not exceeded by more than º Celsius.

The IPCC's mission is to Blank ______.

Why have most international agreements for environmental protection been based on the honor system?

As was exhibited with the Montreal Protocol and the encouragement of reduced CFC production, trade can be an effective tool to compel compliance with international treaties.

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单