I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I can write the simple equation in the cost column to multiply the time with the material. I just can't figure out how to get Excel to assign values to the items on my drop down list.
It seems so simple so I'm guessing there's an easy macro or formula that I can use- I just can't find it yet!
My table looks like this:
A B C 1 Material Time(in hours) Cost 2 3 VHS 1.5 =B3* ? 4 DVD 1.25 5 CD 0.75
I also have a list of the words and there values on another page though this can move: It's these two columns that I need to link I presume?
J K 1 material rate card 2 VHS 30 3 Netsend 25 4 DVD 20 5 FRC 60
I spent 8 hours trying to do this yesterday- help is very much appreciated!!!
(I'm using Excel 2003)