I just decided to do a big IF statement for every cell in another sheet to accomplish what I needed, due to no response and no adaptable (by me anyway) versions found in other threads/forums.