英文:
How can I handle the error and still apply REGEXEXTRACT to other rows in Google Sheets?
问题
这个公式在一个列中查找文件ID，如果找到了键。然而，如果一个键没有找到，似乎会停在那里，但下面的其他行确实有正确的键和文件ID，应该显示图像。我如何处理这些错误，以使公式在下面的行中起作用？
英文:
This formula finds the file ID in one column if the key is found. However, if one key is not found, it seems to stop there, but the other rows below do have the keys ok and the file ID and should display the images. How can I handle these errors, so that the formula works with the rows below?
答案1
得分: 1
<!-- language-all: js -->
*You may try:*
=map(D2:D6;lambda(Σ;image(substitute(substitute(xlookup(Σ;A:A;B:B;);"file/d/";"uc?id=");"/view?usp=sharing";))))
[![enter image description here][1]][1]
[1]: https://i.stack.imgur.com/lp0LI.png
英文:
<!-- language-all: js -->
You may try:
=map(D2:D6;lambda(Σ;image(substitute(substitute(xlookup(Σ;A:A;B:B;);"file/d/";"uc?id=");"/view?usp=sharing";))))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论