我有一个非常大的相关矩阵，很难导航。
我想制作两个下拉菜单来选择两个项目（X 和 Y），并需要 google 表格中的公式来输出相应的相关性。
我知道通过输入行号和列号来执行此操作的方法，如所述 此处 但我想输入行和列中的值，而不是它们的数字。
我将不胜感激的帮助。
谢谢
I have a very big correlation matrix that is very hard to navigate.
I want to make two dropdown menus to select two items (X and Y) and need a formula in google sheets to output the corresponding correlation.
I am aware of the method of doing this by putting the row and column number, as described here but I want to put in the values in the row and column, not their number.
I would appreciate the help.
thank you
发布评论
评论（1）
您只需要将index（）与两个匹配（）公式一起使用。
For example, if I have my drop-downs in B1 and B2 and the data in a Data!床单：
You just need to use INDEX() with two MATCH() formulas.
For example, if I have my drop-downs in B1 and B2 and the data in a Data! sheet: