View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim R Kim R is offline
external usenet poster
 
Posts: 1
Default Look up and Replace

I am trying to popluate worksheet 1 with $ amounts. I want to do this by
looking up an Initial in worksheet 3 and multiplying it by the hours in
worksheet 2. The intial's and column headings will need to be equal to
account for escalation over a period of years.

For example if CB=March 09 then multiply $10.00 * 50 Hours and popluate this
into Worksheet 1.... and so on over a period of years

Sample Data:

Worksheet 1

Initial March 09 March 10 March 11
1 CB
2 AC
3 CC
4 ST
Worksheet 2

Initial March 09 March 10 March 11
1 CB 50hours 30hours 40hours
2 AC 50hours 30hours 40hours
3 CC 50hours 30hours 40hours
4 ST 50hours 30hours 40hours


Worksheet 3

Initial March 09 March 10 March 11
1 CB $10.00 $20.00 $30.00
2 AC $10.00 $20.00 $30.00
3 CC $10.00 $20.00 $30.00
4 ST $10.00 $20.00 $30.00