如何製作 Excel 腳本/巨集來搜尋具有特定資料的儲存格？

Question

有需要

1.to get current active cell (selected one),
2. get data it holds (date DD.MM.YY), 
3. search for the same date in other book (or same), 
4. copy found cell on the right to (Sheet1 right next to date on the right). 

有什麼例子如何做到這一點？

Answer 1

使用 VLOOKUP 函數從列中搜尋符合的索引。

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)