在Excel中使用三个变量进行索引匹配 [英] Index Match with three variables in Excel

问题描述

在左侧的工作簿中，我列出了年份(A列)和国家/地区代码(B列)，然后在第一行中列出了世界银行发展指标名称的长列表(C，D，E，等等.).在右侧的工作簿中，我具有每年和每个国家/地区的每个指标的值.我想做的是使用公式(指数匹配或其他方法)来获取相应年份和国家/地区的指标值.谁能为我提供解决该问题的公式，以便我可以将其应用于所有行和列?预先感谢您的帮助！:)

In the workbook on the left I have a list of Years (column A) and Country Codes (column B), and then on the top row a long list of World Bank development indicator names (columns C, D, E, etc.). In the workbook on on the right I have the values for each indicator for each year and each country. What I would like to do is to use a formula (index match or something else) in order to get the values for the indicators for the corresponding years and countries. Could anyone provide me with the formula that would solve this problem so I can apply it to all rows and columns? Thank you in advance for your help!:)

推荐答案

提供了一个ARRAY公式.您需要按CTRL + SHIFT + ENTER

its an ARRAY Formula. You need to press CTRL + SHIFT + ENTER

{=INDEX($C$4:$E$15,MATCH(1,(A4:A15=$A$25)*(B4:B15=B25),0),MATCH(C24,C3:E3,0))}

这篇关于在Excel中使用三个变量进行索引匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！