Thread: Text returning number in next cell

The workbook currently has a couple of dependent drop down lists. I would like that once a drop down is selected the next cell fills in with the associated value.

In this case the sheet would:

Drop Down Named "Race" Human is selected

Drop Down Dependent on "Race" now allows you to select from its list. Once said one is chosen the cell next to it shows "5"

And look like:

Human
Casting Bonus 5
Casting Bonus 10