英文:
How to use an find best match based on the wording within the same cell
问题
我正在使用Google表格,在其中我需要基于该表中的单词找到最佳匹配。
我们大多数基本查找函数,如VLOOKUP、HLOOKUP、XLOOKUP或INDEX-MATCH,仅支持查找整个单词。
然后我使用了分割函数来{"=SPLIT(E3, " ")},将所有单词拆分到第二个表格中。
然后我编写了公式,使用LET、HSTACK、BYROW、TOROW、CHOOSEROWS和其他公式。以下是公式:
=LET(a,HSTACK($D$2:$D$5, BYROW(IFERROR(ARRAYFORMULA(XMATCH($F$2:$H$5,SPLIT(A2, " "))),0),LAMBDA(x,SUM(x)))),TOROW(CHOOSEROWS(INDEX(SORT(FILTER(a,INDEX(a,,2)<>0),2,1),,1),1)))
但我认为我需要对此进行一些更正,因为这不能提供100%的准确性。
英文:
I am working on
Google sheet, In this I need find the best match based on the word in this sheet.
Our most of the basic Look up function like Vlookup, Hlookup, Xlookup or Index-match only support for Look the whole wording.
Then I used Split function to {"=SPLIT(E3," ")"}, Split all word in 2nd Table.
Then I wrote formula Using LET, HSTACK, BYROW, TOROW , CHOOSEROWS and Other formula.
Below is the formula
=LET(a,HSTACK($D$2:$D$5, BYROW(IFERROR(ARRAYFORMULA(XMATCH($F$2:$H$5,SPLIT(A2," "))),0),LAMBDA(x,SUM(x)))),TOROW(CHOOSEROWS(INDEX(SORT(FILTER(a,INDEX(a,,2)<>0),2,1),,1),1)))
But I think I need to do some correction on this, because this not give the 100% accuracy.
答案1
得分: 1
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论