If cell contains one of many values then get value excel formula

[rajeshn_in]

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.

[rajeshn_in]

Please find the attachment for example.

Thank you

[Ghozi Alkatiri]

at B2
=SUBSTITUTE(TRIM(SUBSTITUTE(IFERROR(MID(A2,FIND($H$2,A2),2),)&IFERROR(MID(A2,FIND($H$3,A2),2),)&IFERROR(MID(A2,FIND($H$4,A2),2),)&IFERROR(MID(A2,FIND($H$5,A2),2),)&IFERROR(MID(A2,FIND($H$6,A2),2),)&IFERROR(MID(A2,FIND($H$7,A2),2),)&IFERROR(MID(A2,FIND($H$8,A2),2),),","," "))," ",",")

copy down

[FlameRetired]

Since you have Office 365 try in cell B2 and fill down.

Please Login or Register  to view this content.