Function based on multiple criteria from two cell references

I

ibrokit

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 5 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top