HI...I'm trying to figure out how to do a long IF THEN statement. I have
three columns. Column 1 is validated data with 20 possibilities. Column two
is validated data with 15 possibilities. I want the third column to
automatically fill in based on the values in columns 1 & 2.

I think if someone can solve the following example, where the third column
is filled in based on the combination of 1 & 2 which are manually entered, I
could modify it to match what I need:

1 2 3
Cheap Lunch Restaurant 1
Cheap Dinner Restaurant 2
Expensive Dinner Restaurant 3
Expensive Brunch Restaurant 3
Expensive Lunch Restaurant 4
Cheap Brunch Restaurant 5

As you can see, there are no calculations involved, only manual entry of data.