we're going to show you how to search

我們將告訴你如何搜索

and find relational data in your spreadsheet

並在您的電子表格中找到關係型數據。

by using the VLOOKUP function.

通過使用VLOOKUP功能。

You'll need to understand the concept

你需要理解這個概念

of a lookup value, range, column number,

的查詢值、範圍、列號。

and exact or approximate matchings.

和精確或近似匹配。

First, click on a blank cell

首先，點擊一個空白單元格

where you want your result to appear.

您希望結果出現的地方。

Go to the "Formulas" tab,

進入 "配方 "選項卡。

and then click "Lookup & Reference."

然後點擊 "查找和參考"。

A drop-down window will appear.

會出現一個下拉窗口。

From the options, select "VLOOKUP."

在選項中，選擇 "VLOOKUP"。

A window will appear on the right-hand side

右邊會出現一個窗口

where you can start filling in

在這裡你可以開始填寫

the details of your search.

您搜索的細節。

In the bar under "Lookup_value,"

在 "Lookup_value "下面的欄中，

add the value you're looking for.

增加你要找的價值。

It can be anything,

它可以是任何東西。

from a name, number, or cell location.

從名字、號碼或手機位置。

We'll enter a name here,

我們在這裡輸入一個名字。

as we're looking for a guest seat number.

因為我們正在尋找一個客人的座位號。

Be wary; the text is case-sensitive,

要注意，文字是區分大小寫的。

so be careful with capital letters.

所以要注意大寫字母。

Under "Table_array,"

在 "Table_array "下

add the area you want Excel to search for your data.

添加您希望Excel搜索數據的區域。

You can do this by typing in a range.

你可以通過輸入一個範圍來實現。

This is the top left cell number

這是左上角的單元號

followed by a colon

後加冒號

followed by the bottom right cell number.

後面是右下角的單元號。

You could add a search area of two columns or more.

你可以添加兩列或更多的搜索區域。

Under "Col_index_num,"

在 "Col_index_num "下，"

you'll need to add the numerical value

你需要添加數字值為

corresponding to the column with your return data.

與您的返回數據列相對應。

In this example, the return data is our seat number,

在這個例子中，返回數據是我們的座位號。

which is in column C.

在C欄中。

The numerical value for this is 3.

其數值為3。

So we'll add this here.

所以我們在這裡加上這個。

Under "Range_lookup,"

在 "Range_lookup "下

you'll need to enter "TRUE" or "FALSE" in capital letters

你需要用大寫字母輸入 "TRUE "或 "FALSE"。

if you want your results to be exact or approximate.

如果你希望你的結果是精確的或近似的。

"FALSE" means you want exact results,

"FALSE "表示你想要精確的結果。

and "TRUE" means you want them to be approximate.

和 "TRUE "表示你希望它們是近似的。

Click down here to start the search.

點擊這裡開始搜索。

Your value will appear in the cell.

你的值將出現在單元格中。