![如何制作搜索具有特定数据的单元格的 Excel 脚本/宏?](https://linux22.com/image/1313072/%E5%A6%82%E4%BD%95%E5%88%B6%E4%BD%9C%E6%90%9C%E7%B4%A2%E5%85%B7%E6%9C%89%E7%89%B9%E5%AE%9A%E6%95%B0%E6%8D%AE%E7%9A%84%E5%8D%95%E5%85%83%E6%A0%BC%E7%9A%84%20Excel%20%E8%84%9A%E6%9C%AC%2F%E5%AE%8F%EF%BC%9F.png)
有需要
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).
有任何例子可以说明如何做到这一点吗?
答案1
使用 VLOOKUP 函数从列中搜索匹配的索引。
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)