Is there an alternative to IF(AND) statements

Hi, there. I am working on modelling a game on excel to help my team. I was wondering if there is an alternative to If (And) statements so that I don't have to waste time on writing a 200 + character formula for each cell. In the excel workbook attached below, sheet 2 has a got a working of a dynamic weather system. On sheet 3 i am trying to model a temperature system. Which will depend on 2 factors, i.e. time of day and Weather Type. For now on sheet 3, I have some standard values for the temperature to its corresponding altitude. What i want to do is to change the temperature when different time of day and weather types are selected. I know this can be done through IF (AND), thats what i did in sheet 2 for the dynamic weather system. But I am trying to find a way to do this is in a much easier way where i will not have to do the same thing over and over again to get the right values.

Originally Posted by FDibbins

I would suggest that you create a small table with the possible combo's and the temps, and then use a simple vlookup() to return the value

	F	G
3	dayhigh	30
4	daymedium	25
5	daylow	40
6	nighthigh	15

Thn for the calc, use this...
=VLOOKUP($A$3&$B$3,Sheet3!$F$3:$G$6,2,0)

Thanks a ton, that sure helps me to get started. I made a table on sheet 3 considering all the possibilities of decrease/increase in temperature. How do I make changes in the Temperature row according to the table on the right when the conditions on B1 and B2 are selected.
I am attaching a version with the table where i have listed down the possibilities on sheet 3

Some help will be really appreciated.