Hi All,
First off, let me thank all of you who responded to my dilemna, I really appreciate your efforts and replies. I have not had the chance to try these soltions yet, but zai will. I will comment that there are reasons that I i went with tht particular approach that I did - mainly becuase I have used IF before, and have no idea about lookup tables. I also tried IF(OR, but was not able to get that to work for me either, the way I originally wanted. I only use spreadsheets occasionally, so have never really learned how to use them. Almost everytime to do use them, I learn a thing or two I did not know before. I probably should have come here before my problems, I could have started with the best solution and avoided a lot of failure.

I found it interesting that one reply said it worked for them as is, if I understood the post correctly. For now, I will look over the replies, and try to understand them. I have 152 more cells in this spreadsheet to do with variations of the same bit of code, so maybe I should upload a file, as one poster suggested, then maybe it will be obvious to some of you that there is a hugely better approach.

There is some propriatory information in the file as is, I will need to strip it of those functions before I can do so. Once you see where this section of the sheet is going, maybe I can get advice that suits my purposes the best, so maybe hold off an any further replies until then. I will also insert dome commentary in the file explaining my ideal goal - the way it is now, is a compromise because I could not figure out a way to pull it off - just my ignorance I am sure.

Again, thanks so much, you people are great!