Quote Originally Posted by preferiti View Post
thanks for the advice on the Match. btw, i took your advice to make life easier, i put them in alpha order. BUT, (lol) it's not letting me combine two cells together like i want it. Is it not possible or is it and i'm just (still)stupid?

I'm trying to do this.

=MATCH(E4,{"Atlanta","Baltimore","Chicago","Cleveland","Detroit","Florida","Kansas City","Los Angeles","Minnesota","New York M","New York Y","Oakland","Philadelphia","Seattle","Tampa Bay","Texas","Toronto","Washington{"(CONCATENATE(Scores!J74,"-",Scores!J75)","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18"})
Is there another way?
In this form, you should use LOOKUP not MATCH.

If Baltimore is the only one to get that concatenantion, do an IF test for Baltimore, and exclude them from the LOOKUP.