How to check if more than 1 matching value in table column?

Help Something Else
, , , ,
1

Hi There,

I have a Array = A,F,X,Y,Z.

Also I have a Table column

Column Name
A
B
C
D
E
F

Here I want to compare array of string with column and find if more than 1 array value is matching in Table or not.
Like A,F (More than 1 array value present in table).

If only single value is present than code should not display anything.

How to achieve this ?

2

Hi @Muralikrishna_Surve

You can convert the column names into an array and you can compare both arrays by which you can achieve the desired result. Hope this helps.

3

HI @Muralikrishna_Surve
Please find the attached file.

Vlookup.zip (29.7 KB)

Regards
Mohini,