☰

搜索值并放入 Excel 中的另一个单元格中

tag-icon • tag-icon microsoft-excel worksheet-function
搜索值并放入 Excel 中的另一个单元格中

eurusd我希望 Excel 在线在此图表上输入示例值 0.01 。

我不知道如何从另一个单元格值来做到这一点。

我尝试了 vlookup 函数但无法使其在表中正常工作。

我希望它查看一列，并自动输入点值（如果可以从 Excel 电子表格的顶部输入）。

这是我的代码，但在 Excel 在线版中不起作用：

=XLOOKUP(A2,{"AUDCAD","AUDCHF","AUDJPY","AUDNZD","AUDUSD","CADCHF"," CADJPY"},"CHFJPY","EURAUD","EURCAD","EURJPY","EURNZD","EURUSD","GBPAUD","GBPCAD", "GBPCHF","GBPJPY","GBPNZD","GBPUSD","NZDCAD","NZDCHF","USDCAD","USDCHF","USDJPY", "EURGBP","EURCHF","NZDJPY"},{0.0073,0.011,0.0071,0.006,0.01,0.011,0.0071,0.0071,0.0065,0.0073,0.0071,0.006,0.01,0.0065,0.0073,0.011,0.0071,0.006,0.01,0.0073,0.011,0.0073,0.011,0.0071,0.012,0.011,0.007})

在此处输入图片描述

答案1

这应该可以完成这项工作：

=IFERROR(INDEX($B$4:$E$4,MATCH($B9,$B$3:$E$3,0)),"")

将此公式放入单元格 N9，然后将其复制到 N 列。我假设您在 B3:E3 中有要查找的值。如果有更多值，请相应扩展此范围。

$可以$B9省略，它只是允许将公式安全地复制到另一列。

您将获得以下内容： 最小示例的结果

绝对引用（美元符号）是必需的。否则，范围 B4:E4 和 B3:E3 将发生变化，而在本例中它们应该保持不变。有关绝对与相对单元格引用的详细说明，例如，请参见Microsoft 支持页面。

相关内容