Help with Search Text Criteria and Output Corresponding Text

Hello, I'm new to excel but I've got big dreams!

I would like to make a formula that looks for certain text in one cell and then outputs a corresponding text into the other cell. This is the formula I'm using right now. If anyone could direct me to more info or the right formula for this function I'd be grateful.

Basically what I'm trying to do is:

Look in B1 for these values

=Lookup(B1{“*MADED”,“*VADED”,”*MAUD”,”*VAUD”,”*MB”,“*VB”,”*MCAR”,”*VCAR”,”*MCDM”,”*VCDM”,”*MCDR”,”*VCDR”,”*MDVD14”,”*VDVD14”,”*MDVDF”,”*VDVDF”,”*MDVDP”,”*VDVDP”,”*MFIC”,”*VFIC”,”*MFORA”,”*VFORA”,”*MFORB”,”*VFORB”,”*MJAUD”,”*VJAUD”,”*MJCDM”,”*VJCDM”,”*MJDVD14”,”*VJDVD14”,”*MJDVDF”,”*VJDVDF”,”*MJDVDP”,”*VJDVDP”,”*MJE”,”*VJE”,”*MJF”,”*VJF”,”*MJMYS”,”*VJMYS”,”*MJNF”,”*VJNF”,”*MJPAR”,”*VJPAR”,”*MJPB”,”*VJPB”,”*MJPER”,”*VJPER”,”*MJPIC”,”*VJPIC”,”*MJPP”,”*VJPP”,”*MJPROF”,”*VJPROF”,”*MJPUP”,”*VJPUP”,”*MJR”,”*VJR”,”*MJRC”,”*VJRC”,”*MJREAD”,”*VJREAD”,”*MJRNJ”,”*VJRNJ”,”*MJRNJC”,”*VJRNJC”,”*MJSC”,”*VJSC”,”*MJSF”,”*VJSF”,”*MJVID14”,”*VJVID14”,”*MJVIDP”,”*VJVIDP”,”*MJX”,”*VJX”,”*MLLS”,”*VLLS”,”*MLP”,”*VLP”,”*MLP14”,”*VLP14”,”*MLPC”,”*VLPC”,”*MMMAC”,”*VMMAC”,”*MMYS”,”*VMYS”,”*MNEWF”,”*VNEWF”,”*MNEWNF”,”*VNEWNF”,”*MNEWS”,”*VNEWS”,”*MNF”,”*VNF”,”*MPB”,”*VPB”,”*MPER”,”*VPER”,”*MPERC”,”*VPERC”,”*MPROF”,”*VPROF”,”*MR”,”*VR”,”*MRBUS”,”*VRBUS”,”*MRC”,”*VRC”,”*MREAD”,”*VREAD”,”*MRILL”,”*VRILL”,”*MRIND”,”*VRIND”,”*MRNJ”,”*VRNJ”,”*MRR”,”*VRR”,”*MRVF”,”*VRVF”,”*MSF”,”*VSF”,”*MSG”,”*VSG”,”*MSS”,”*VSS”,”*MTUT”,”*VTUT”,”*MVID14”,”*VVID14”,”*MVIDF”,”*VVIDF”,”*MVIDP,”*VVIDP”,”*MWEST”,”*VWEST”,”*MYA”,”*VYA”},


and if it sees that value, output this corresponding text.


{“MAnf”,”VAnf”,”MAudio”,”VAudio”,”MAnf”,”VAnf”,”MCareer”,”VCareer”,”MCDs”,”VCDs”,”MCDRom”,”VCDrom”,”MDVD”,”VDVD”,”MDVD”,”VDVD”,”MDVD”,”VDVD”,”MAF”,”VAF”,”MAudio”,”VAudio”,”MForeignLang”,”VForeignLang”,”MJAudio”,”VJAudio”,”MJCD”,”VJCD”,”MDVDJ”,”VDVDJ”,”MDVDJ”,”VDVDJ”,”MDVDJ”,”VDVDJ”,”MJF”,”VJF”,”MJF”,”VJF”,”MJF”,”VJF”,”MJNF”,”VJNF”,”MPaperbaJ”,”VPaperbaJ”,”MPeriodJ”,”VPeriodJ”,”MJF”,”VJF”,”MJF”,”VJF”,”MJF”,”VJF”,”MPuppetJ”,”VPuppetJ”,”MJNF”,”VJNF”,”MJF”,”VJF”,”MJNF”,”VJNF”,”MJNF”,”VJNF”,”MJF”,”VJF”,”MJF”,”VJF”,”MVideo”,”VVIdeo”,”MVideo”,”VVideo”,”MVideo”,”VVideo”,”MJF”,”VJF”,”MPeriod”,”VPeriod”,”ML”,”VL”,”MAfLP14”,”VAfLP14”,”MLPC”,”VLPC”,”MMultimac”,”VMultimac”,”MAF”,”VAF”,”MAF”,”VAF”,”MAF”,”VAF”,”MAnf”,”VAnf”,”Mperiodicals”,”VPeriodicals”,”MAnf”,”VAnf”,”MPaperba”,”VPaperba”,”MPeriodical”,”VPeriodical”,”MPeriodical”,”VPeriodical”,”MAnf”,”VAnf”,”MAnf”,”VAnf”,”MAnf”,”VAnf”,”MAnf”,”VAnf”,”MAf”,”VAf”,”MAnf”,”VAnf”,”MAnf”,”VAnf”,”MAnf”,”VAnf”,”MAnf”,”VAnf”,”MPamphlet”,”VPamphlet”,”MAf”,”VAf”,”MAnf”,”VAnf”,”MAf”,”VAf”,”MTutor”,”VTutor”,”MVideo”,”VVideo”,”MVideo”,”VVideo”,”MVideo”,”VVideo”,”MAf”,”VAf”,”MAf”,”VAf”})

Again I would be very appreciative of any help or direction you might please offer.

Thanks in advance for taking the time to read through my post.
Al_Tambooka