I got some help earlier with an IF Statement which was very helpful from Mike
H. The idea I am going for now is if I have the following ("Wireless
Laptop","Desktop Computer","Flatscreen Monitor","Server","Solar
Panels","I-Phone","I-Pod","Dual Screen Monitor Stand","Wirless Router") I
will get one of the following associated acronyms.
("JERA","SHJK","MCJM","MOPQ","ABPE","POMZ","PDAI", "COPN","HLMW"). In other
words the 1st item on the 1st list needs to match the 1st acroynm on the 2nd
list


Here is the original formula
=LOOKUP(B7,{"H","K","M","P"},{"JER","SHJ","MCJ","M OP"}) that Mike H helped me
with. I wanted to try chaning it around for a different use. Here is what I
have now =LOOKUP(D15,{"Wireless Laptop","Desktop Computer","Flatscreen
Monitor","Server","Solar Panels","I-Phone","I-Pod","Dual Screen Monitor
Stand","Wirless
Router"}{"JERA","SHJK","MCJM","MOPQ","ABPE","POMZ" ,"PDAI","COPN","HLMW"})
some of them work and some of them don't and I couldn't figure out why.
Any thoughts?