Cell auto fill based on another field drop down list selection

you can either use vlookup() or index() with match(). Please post a sample work book if you need any more help.

Thanks, vlookup() function worked almost perfectly!