extract id numbers from partial text

[beepetark]

Hai, to excel experts

here i am attaching the file where we can extract id numbers from partial text and if found it has to show "id number mentioned", if it is wrong then have to mention "id is wrong", else mention id number not found

[PaulM100]

Not clear. For last 3 entries, where the id should be mentioned is wrong, no ID saw.

[Glenn Kennedy]

Beepetark. Please check your example. It does not make sense!!

[beepetark]

i am attaching another file here please help me
if you find full id number then id is correct, if the id number is not full mentioned then incorrect id
and if id number is not found then no id found

[Glenn Kennedy]

There is BOUND to be a better way!!!

=IF(EXACT(-LOOKUP(1,-RIGHT(TRIM(LEFT(A2,FIND(")",A2)-1)),{1,2,3,4,5,6,7,8,9})),B2),"ID Mentioned",IF(ISNUMBER(SEARCH(-LOOKUP(1,-RIGHT(TRIM(LEFT(A2,FIND(")",A2)-1)),{1,2,3,4,5,6,7,8,9})),B2)),"Incorrect ID",IF(ISNUMBER(SEARCH(B2,-LOOKUP(1,-RIGHT(TRIM(LEFT(A2,FIND(")",A2)-1)),{1,2,3,4,5,6,7,8,9})))),"Incorrect ID","ID Missing")))

[PaulM100]

One way:

Please Login or Register  to view this content.

[Bosco]

Another option,

=IF(LOOKUP(9^9,-RIGHT(A2,ROW($1:$9)))=B2,"ID Mentioned",IF(OR(1-ISERR(FIND(LOOKUP(9^9,-RIGHT(A2,ROW($1:$9))),B2)),1-ISERR(FIND(B2,LOOKUP(9^9,-RIGHT(A2,ROW($1:$9)))))),"Incorrect ID","ID Missing"))

Regards
Bosco

[Bo_Ry]

Another one
C2
=IFERROR(IF(LOOKUP(9^9,-RIGHT(A2,ROW(A$4:A$9)))=B2,"ID Mentioned","Incorrect ID"),"ID Missing")