Populate cells from making a drop down selection

[ipbr21054]

Afternoon.

Im looking for some advice on how to pull in some info to save repetitive drop down selecting.
I would like to select a value from a drop down in column B & have the cells to the right being Column C,D & E populated.
I dont realy want to use an IF statement all down the page as in the past users have manually input a figure & lost the IF code.

Some info for you.

Column B is where the drop down in situated.
If TA HEW is selected then populate the following cells accoringly in the same row.
Column C HO
Column D £26.00
Column E HEW

If TA MP is selected then populate the following cells accoringly in the same row.
Column C HO
Column D £8.70
Column E MP

If a range is required then its A4:E28

Many Thanks