Posting images depending on cell value

[HunterA]

Hello, thanks in advance for your help!!

I am trying to use a master menu (for my food service operation) sheet to collect information about menu items and then transfer them to individual station menus.

I have most of it figured out, I need to use a check box,(mark here for vegan, mark here for vegetarian) or a fillable (VG, VN, blank) cell on the master menu sheet to either display an (vegan, vegetarian, or no) icon on the individual station sheets.

For example, on sheet 'Menu Master' I wish to fill cell b11 or h11 with either vg, vn, or nothing and have two corresponding cells on sheet 'Breakfast' fill with either a vegan, vegetarian, or no icon. ('Breakfast' f15, or f22 for the two places I want images to appear)

I can have a hidden back sheet to register the images if I need to.

Thanks again for the help, and let me know if I can clarify anything about this request!

-Alex

 

[HunterA]

I have already found match/lookup, but when I use it, the cell that I change affects all the images at once, not the individual images!! Or I may not be using it effectively.

Thanks