Need to fill adjacent cells after selecting something from a drop down list

Hey Guys

I've been working on solving this problem for what seems like all day now. I am a pharmacy intern and I have been assigned to make a spreadsheet that helps us track the cost savings of interventions. Each intervention has a dollar value associated to it. I have been searching forums and trying out what I've been reading but I keep getting a reply that says "#VALUE"

I want to set this spread sheet up so that when a user chooses the appropriate intervention from the "intervention" column (which is a drop down located in Column D on my Savings sheet tab) the following columns (E,F,G which corrolate to "intervention class," "Soft $ Saved," and "Hard $ Saved") automatically fill in.

My second tab labeled "Legend" has all the interventions and data that I want to be automatically displayed once I choose an intervention from the drop down menu in column D of my "Savings Sheet" Tab

Essentially I want to choose an option from a drop down list, and have adjacent cells across a row automatically fill in.

Del_pals,

This is a 2 yr old thread. There is not much chance of you getting a reply.

Why dont you create a new thread of your own? Someone here can surely help you.