Hi Friends,

I have one formula issue. Please check below.

IF "A1" VALUE AS = 1, 2, 3, A, E, 6, G

LIST OF VALUES TO CHECK
A
B
D
F
I
G

REQUIRE FORMULA IN B2

SO, I WANT B2 = A, G (BECAUSE A1 HAVE "A" & "G" VALUES FROM LIST OF VALUES.)


IF A1 VALUE AS = 1, 2, 3, A, E, 6
HERE A1 HAVE ONLY ONE VALUE OF LIST OF VALUES THEN
B2 = A


Please send the required formula


Thank you.