Hello,

I have created a list of options, lets say days, monday ~ Sunday.

Then I have a cell c2 where a user would validate from that list to pick a
day.

What I would like to do is link the results in C2 (days of the week) to a
seperate list of information in cell C3 where say, the lunch menu apprears.

So say monday lunch is tacos and tuesday lunch is pizza I would like a
formula something like (and I know the syntax is all wrong that's why I'm
looking for help :( ) if c2=monday, than c3 = tacos.

Is this possible?

Thanks & Cheers to all.