查找A列中的值是否包含B列中的值? [英] Find if value in column A contains value from column B?
问题描述
我有两列-E列可扩展到99504(值),I列可扩展到2691(值).这两列都包含扩展名的文件名.
I have two columns- column E which extends upto 99504(values) and column I which extends to 2691(values).Both the columns contains filenames with extension.
类似这样的东西
E I
TSL_groups.mrk pcbx_report.mrk
abcd.mrk jhuo.mrk
以此类推...
我想查找E列(标题Filename_A)中是否存在I列(标题Filename_B)中的文件.如果为true,请在新列中将TRUE设为K列.
I want to find if the files in column I (heading Filename_B) exists in column E(heading Filename_A). If true, say TRUE in a new column let's say column K.
我该怎么做? TIA.
How do I do that? TIA.
推荐答案
您可以尝试
=IF(ISNA(VLOOKUP(<single column I value>,<entire column E range>,1,FALSE)),FALSE, TRUE)
-或-
=IF(ISNA(VLOOKUP(<single column I value>,<entire column E range>,1,FALSE)),"FALSE", "File found in row " & MATCH(<single column I value>,<entire column E range>,0))
您可以用命名的ranged替换<single column I value>
和<entire column E range>
.那可能是最简单的.
you could replace <single column I value>
and <entire column E range>
with named ranged. That'd probably be the easiest.
只需将该公式一直沿I列的长度拖到想要的任何列中即可.
Just drag that formula all the way down the length of your I column in whatever column you want.
这篇关于查找A列中的值是否包含B列中的值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!