Hello,

I'm stumped on finding the right function for this. I have one cell with
 a pick list of three bowling centers. The cell below it has a pick
list of the names of five oil patterns (names of the way the maintenance
man applies oil to the lanes). In the cell below that, I'd like to be
able to select the name of the bowling ball I'd like to use. So it goes
like this:
If the Bowling center is Bowl-a-Rama, and the lane pattern is the Viper,
use the Brunswick Ultimate Inferno ball. If the bowling center is Taylor
Lanes, and the pattern is the Shark, use the Hammer No Mercy ball, and
so on.
Right now I have 3 centers, 5 patterns and five balls to use.  Once I
get the syntax figured out I can expand on it. I greatly appreciate any
help anyone can offer.
Thanks so much.