Hi There,

I have 2 worksheets in Excel 2013 . Worksheet1 Column A has a list of data such as below

/vol/dev_esxi_boot_luns/devesx01
/vol/dev_esxi_boot_luns/devesx02
/vol/dev_vmfs_vmstore/dev_vmfs_vmstore_lun
/vol/dev_vmfs_vmstore/dev_vmfs_vmstore_lun
/vol/dsf_data_vol/dsf_data
/vol/dsf_jd_vol/dfs_jd_data
/vol/dsf_jd_vol/dfs_jd_quorum
/vol/dsf_jd_vol/dfs-jd-namespace
/vol/esxi_boot_luns/exesx01/lun1

Woksheet2 Column A also has a list of data like below

backup_vmstore01
default_profile
dev_esxi_boot_luns
dev_vmfs_vmstore
dsf_data_vol
dsf_jd_vol
esxi_boot_luns
esxi5_syslog
excas1

Now i need another to for each row in ColumnA worksheet2 see if that text exists within Worksheet 1 ColumnA and output true or false in ColumnB worksheet2

So for instance, the 3rd line in ColumnA worksheet2 is dev_esi_boot_luns, this exists with the text on Worksheet1 ColumnA on row 1,2 and 3 and so woould be "True"

Thanks for taking the time to read this

Best Regards

Byron