Which formula would work best in this case?

**LIZCONSTRUCTION** · 04-07-2010, 04:39 PM

I am setting up an invoice ticket for construction. We have different employees with different trades, which also means a different payscale. I am trying to set it up so that once their trade is entered, the value of that trade is automatically entered in a cell next to it. I thought the IF formula would work, but I am not using all values so I can't get it to work properly.

Example:
I11=Trade (I've created a drop-down list with all five trades that apply)
L11=Hourly Rate (As it stands I manually enter their rate)

So in a perfect (Excel) world, if I choose "Foreman" from the drop-down menu, the L11 cell will be automatically filled with the Foreman's hourly rate.

THANKS!

**NBVC** · 04-07-2010, 04:41 PM

Sorry to be a pest, but you need to do a bit better.....

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.