ive reached the end of my rope. this is a project for a college engineering class and basically needs to be as "pretty" and as user friendly as possible.
so heres the scenario.

i have 2 data validation dropdown lists. the first one is loaded with lets say animals: dogs, cats, birds.
the second list is loaded with all subcategories of that, allowing for a combination selection if you will... (labs, yorkies, poodles, siamese, tabby, blue jay, robin, crow, etc.)

counting it up theres more than 64 combination which i hear is the limit for nested statements for a particular cell.

but what i need is when the user selects a combination like (dog,lab) or (cat,tabby) for a single cell to generate a code, (D-LAB) or (C-TAB)... this code will be used for an index lookup to change the picture located below the two validation lists to what its supposed to be. (lab or tabby etc)

i finally figured out the pic lookup but i can not for the life of me figure out how to set up outcomes for my very large lists...

and heres the kicker. i cant use macros or VB. as in not allowed.
any help is GREATLY appreciated.