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