提示: 使用 VLOOKUP 的訣竅，便是整理您的資料，讓要查閱的值 (Fruit) 位於要尋找的傳回值 (Amount) 左側。 如果你是Microsoft Copilot 訂閱者，Copilot 可以讓你更容易插入和使用 VLookup 或 XLookup 功能。 你看， Copilot 讓 Excel 查詢變得簡單。

Aprenda a usar la función BUSCARV en Excel para buscar datos en una tabla o rango por fila. Nuestra guía paso a paso hace que buscar vlo en Excel sea fácil y eficiente.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

提示: VLOOKUP 的秘诀在于组织数据，这样您查找的值（水果）位于要查找的返回值（金额）的左侧。 如果你是Microsoft Copilot 订阅者 Copilot 可以更轻松地插入和使用 VLookup 或 XLookup 函数。 请参阅 Copilot 使 Excel 中的查找变得简单。

A complete list of all Excel functions in alphabetical order.

How to use the LOOKUP function in Excel to search in a single row or column and find a value from the same position in a second row or column.

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.

VLOOKUP is one of the most popular, useful functions in Excel, but it’s hard to remember the formula if you don’t use it that often. If all you want is the syntax for VLOOKUP, here it is: VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) To download a reference card that explains what the arguments mean and how to use them, click the link below. The VLOOKUP reference card ...

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.