騷客。眼迷離。

VLOOKUP和HLOOKUP十分類似，只是VLOOKUP是找直的欄位，HLOOKUP是橫的列位。

範例

下圖為分別是2個獨立的excel檔案，Book 1缺下單數量，Book 2缺單位用量，兩個檔案排序也不一樣，利用函數VLOOKUP綜整2份檔案成1份。

※以Book 1為主要檔案，Book 2為搜尋用的次要檔案。

Solidworks模型組態-表格設計

利用Excel表格設計繪圖增加工作效能，也易於管理。

Which is right?

□ 1. Let's go counterclock around the table and hear everyone's opinions.

□ 2. Let's go counterclockwise around the table and hear everyone's opinions.

Execl-欄列換置

有時候需要將Excel的欄與列的位置對調，但又不想從新key in，可以運用下列簡單的小技巧。

 ※框選要轉置的區域，按右鍵點選複製

Which is right?

□1. We should oppose this new law because it intrudes people's privacy too much.

□2. We should oppose this new law because it intrudes on people's privacy too much.

Which is right?

□1. School is the north Taiwan were closed during the typhoon.

□2. School is the north of Taiwan were closed during the typhoon.

Which is right?

□1. We should extend our age level from 17 to 40.

□2. We should extend our age range from 17 to 40.

Which is right?

□1. Thanks for helping this project.

□2. Thanks for helping with this project.

Which is right？

□1.Last night my boyfriends and I had a wonderful candle-lit dinner.

□2.Last night my boyfriends and I had a wonderful candle dinner.