在Excel中使用数组公式实现多表联动查询

The Implementation of Multi-tables Linkage Queries to Use Array Formula in Excel

Excel的数组公式有着非常重要的作用,应用得当能极大地提高我们的工作效率。本文通过实例比较详细地介绍了Excel数组公式在多表联动查询中的应用。

It＇s a very important function to an array formula of Excel,and it can dramatically improve our work efficiency.This paper introduces the application of Excel array formula in multi-table linkage query by a living example.