Hello,
I read this article (Ensure accurate data entry in Excel by using Data Validation to create drop-down lists)and I am constantly using the drop down list in my excel sheets. However, there is a piece of functionality that I am having difficulty with. I have 4 items in my list in column A: Project Management, Internet Programming, Graphic Design and Purchase. I have a second list in column B that are for hours: 0,1,2,3,4. What I would like to do is to assign a dollar value to each item in column A one and have excel populate column C with the correct dollar amount. For example, Project Management would be worth $25.00 and if I worked 2 hours as PM, then column C would read $50.00. I tried using the ‘IF’ formula in column C, but failed miserably at.
Does any one have any suggestions for me?
Thanks.