最初打开的文件大概是365版本打开/保存了2016年。公式现在在365中不起作用
我有一个最初从一个 drive 下的文档文件夹中保存/工作的文件。然后将其移至共享驱动器，当我打开它时，它使用了Excel 2016。我发现某些公式/功能仅在365中可用，所以我在计算机上安装了它，下次我打开它时，它说它使用了Excel 365。但是，公式无法正常工作。
我有一个TAB，List_state_6.10.2022，看起来像这样：
A G ... J ... S
1 Device Org ... component ... Display ... Comp+Display
ABC123 co ... part1 ... Not Found ... part1+Not Found
ABC234 co ... part2 ... ok ... part2+ok
ABC123 co ... part3 ... ok ... part3+ok
我有一个FinalResult选项卡，它试图在上面此选项卡中进行多个查找以查找状态，并将每个设备编号的每个设备编号附加到同一单元格中的每个单元格中。这曾经工作，我不确定为什么它停止工作。
A W
1 Device ... Component+ErrorState
2 ABC123 ... #Name?
W2应该显示：找不到Part1+part3+OK
W2中的单元格公式为：
{=TEXTJOIN("; ",TRUE,(_xlfn.LET(_xlpm.data,List_State_6.10.2022!S:S,_xlpm.filterlist,List_State_6.10.2022!A:A,_xlpm.lookup,A2,TRANSPOSE(_xlfn._xlws.FILTER(_xlpm.data,_xlpm.filterlist=_xlpm.lookup,"NA")))))}
此公式返回#Name？
我尝试删除_xlpm，看起来像这样，但仍然返回#Name？
=TEXTJOIN("; ",TRUE,(LET(data,List_State_6.10.2022!S:S,filterlist,List_State_6.10.2022!A:A,lookup,A2,TRANSPOSE(FILTER(data,filterlist=lookup,"NA")))))
我在这里有点不确定它为什么有#Name？现在，不是发现的错误，或NA。它曾经工作。当我打开正常运行的旧电子表格时，它说它在365中打开它，当我将配方奶器拖动时，它充满了#name？我不确定如果我现在使用365，为什么公式停止工作。
我的问题是如何使这个公式再次工作？
谢谢你！
更新： 这是我的旧问题，那时似乎在起作用，但是现在它不起作用。我从未使用过网络版本。 stack溢出索引返回多结果
I have a file that was originally saved/worked on from a documents folder under One Drive. It was then moved to a share drive, and when I opened it, it was using Excel 2016. I found out some formulas/functions are only available in 365, so I got that installed on my computer, and the next time I opened it, it says it's using excel 365. However, the formulas are not working still.
I have a tab, List_State_6.10.2022 that looks like this:
A G ... J ... S
1 Device Org ... component ... Display ... Comp+Display
ABC123 co ... part1 ... Not Found ... part1+Not Found
ABC234 co ... part2 ... ok ... part2+ok
ABC123 co ... part3 ... ok ... part3+ok
I have a FinalResult tab that is trying to do multiple lookups in this tab above to find states, and appending each one found for same device number into the same cell for w2. This used to work and I'm not sure why it stopped working.
A W
1 Device ... Component+ErrorState
2 ABC123 ... #Name?
w2 should show: part1+Not Found;part3+ok
The cell formula in w2 is:
{=TEXTJOIN("; ",TRUE,(_xlfn.LET(_xlpm.data,List_State_6.10.2022!S:S,_xlpm.filterlist,List_State_6.10.2022!A:A,_xlpm.lookup,A2,TRANSPOSE(_xlfn._xlws.FILTER(_xlpm.data,_xlpm.filterlist=_xlpm.lookup,"NA")))))}
This formula returns #name?
I tried removing the _xlpm's and it looks like this but still returns #name?
=TEXTJOIN("; ",TRUE,(LET(data,List_State_6.10.2022!S:S,filterlist,List_State_6.10.2022!A:A,lookup,A2,TRANSPOSE(FILTER(data,filterlist=lookup,"NA")))))
I'm a little unsure here why it has #name? now and not a found error, or NA. It used to work. When I open the old spreadsheet that worked fine, it says it's opening it in 365, and when I drag the formula cell down, it fills all with #name?. I'm not sure why the formula has stopped working if I'm using 365 now.
My question is how do I get this formula to work again?
Thank you!
Update:
This was my old question, and it seemed to work back then, but now it's not working. I never used a web version.
stack overflow index return mult results
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
对的答案如何使这个公式再次工作？安装了支持所有已使用功能的Excel版本。
_xlfn。，_xlfm。，_xlws。前缀表示功能有效，但在Excel的已安装版本中不支持。在支持该功能的版本中打开工作簿时，他们应该失望。似乎
让在。 Nofollow Noreferrer“>版本2009（构建13231.20262）The answer to how do I get this formula to work again? is install a version of Excel that supports all the used functions.
The
_xlfn.,_xlfm.,_xlws.prefixes indicate the function is valid but not supported in the installed version of Excel. They should disapear when the workbook is opened in a version that supports the function.Seems
LETwas introduced in Version 2009 (Build 13231.20262)