How do I populate cells (with numbers) from a dropdown (in text) menu in a timesheet?

I would make a table on a separate sheet similar to this :

	Wk-	Trv-1	Trv-2
104016.8041.1 Labor	10	10	10
104016.8041.2 Danger Pay	8	0	0
104016.8041.3 Post Differential	8	0	0
104016.8041.4 PTO Post Differential	0	8	8
600000.001 Engility Paid Time Off	0	0	0
600000.002 Engility Holiday	0	0	0
600000.003 Engility Floating Holiday	0	0	0
600000.008 Engility Leave w/o Pay	0	0	0

(add more columns as needed)
Then for the Values use (assuming this table starts in A1 on Sheet3)this in G5:

Formula:

Please Login or Register  to view this content.

The red 'S''s are just a guestimate as to how many columns you'll need, change if needed
Drag the formula down

Note- All those merged cells may cause problems when moving the formula across,or may not

Hope this helps

The table needs to be created first..you have the names for everything, but there is no place to find the hours for the PTO value...RE-READ my post (#2).. if you supply the table in an uploaded workbook, I (or someone else) CAN give you the solution, but as it is, we have NO way of knowing what the hours are for a particular choice (2 we know; the other 15-18 we do not)

Okay, I adjusted the Ranges, and I'm getting the right values, so I'm not sure what the problem is ? (AND...I did tell you those merged cells will be a pain, You need to copy/paste the formula to new area's now..and get them right, not easy with merged cells...... )
As it is set up, I only have the values in your green high-lighted cells in Column F(&G&H), otherwise, I would have to break all those merged cells, just to get the formula into 1 of them, Better to use 'Center across selection' than 'Merge and Center'

Hope this helps

EDIT-
An old-time programmer's mantra "Make it WORK first,THEN make it look "pretty"..."

You are very welcome !