我有一个 Excel 文档，我想列出符合三个条件的所有值。
工作表1：
Year Player Pos Cluster
2018 Joe C 1
2018 Ken RW 2
2018 Bill C 1
2018 Ryan C 1
2017 Joe C 1
2017 Ken RW 2
我想返回所有与年份、位置和给定名称的集群相匹配的球员姓名。
Sheet 2 应如下所示：
Player Pos Cluster
Joe C 1
Similar Players
Bill
Ryan
这是我编写的函数，但它只返回相同的名称：
=INDEX('Base Player Data'!B:B,MATCH(1,('Base Player Data'!AZ:AZ='Individual Player Projections'!K1)*('Base Player Data'!A:A='Individual Player Projections'!B6)*('Base Player Data'!E:E='Individual Player Projections'!E1),0))
任何帮助将不胜感激！