4

Find if the value in column A contains the value in column B?

 3 years ago
source link: https://www.codesd.com/item/find-if-the-value-in-column-a-contains-the-value-in-column-b.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

Find if the value in column A contains the value in column B?

advertisements

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.

Something like this

E               I
TSL_groups.mrk  pcbx_report.mrk
abcd.mrk        jhuo.mrk

and so on...

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.

How do I do that? TIA.

You could try this

=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))

you could replace <single column I value> and <entire column E range> with named ranged. That'd probably be the easiest.

Just drag that formula all the way down the length of your I column in whatever column you want.


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK