TOUGH ONE...multiple IF conditions

[darcyfournier]

I have cells that have names as follows

Aspen
Laural
Maple
Pine wood

I want to assign the cell next to it to display a number based on one those names.

Is Cell A is Apsen Cell B is 200, If its Laural, Cell B is 250, If it is Maple cell B is 300 etc.

I tried to do this =if(a1="Aspen",200,"Laural",250,"Maple",300) etc. but is said I have too many arguements.

Is what I am describing even possible?

 

[AhoyNC]

Here are a couple options one using LOOKUP and one using IF function.

Excel Workbook
	A	B	C	D
1	Maple	300		300
2
Sheet