How can I implement this flexible If/And concept?

**rrbest** · 10-29-2010, 10:24 PM

I am creating a tool to show seasonality for the twelve months. On the LookUp tab I have it set up so that it reflects the correct numbers for the month depending on the value determined in Revenue!C1 and the Lead Season. Cell B4 allows users to pick from a drop down munue the first month, when they do this, it is automatically dragged out for the remaining 11 months.

I need the numbers in Revenue!B5:M5 to correctly display the appropriate number from the table on the LookUp tab. I have created a formula in cell B5 that shows how it should respond if June and Fall are selected by the user.

Unforunately, the question I have is that I have no idea how to get this number to adjust correctly when the user changes the Lead Season variable and the Starting Month (makes changes in cell B2 and B4)

Any help would be greatly appreciated.

**JBeaucaire** · 10-29-2010, 10:30 PM

Put this formula in B5 and copy to the right:

=INDEX(LookUp!$B$3:$E$14, MATCH(B$4, Months, 0), MATCH($B$2, Seasons, 0))

**arthurbr** · 10-30-2010, 04:00 AM

BTW, maybe avoid using function names as tab names.

**JBeaucaire** · 10-30-2010, 04:41 AM

Thanks for the feedback, rrbest.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.