Welcome libin baby,

Something like =IFERROR(IF(SEARCH(B1,"XXXX",1),VLOOKUP(A1,tablearray,12,0)),FALSE)

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".