LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace - Replace with Blank Space Studebaker Excel Discussion (Misc queries) 4 April 3rd 23 10:55 AM
Can I replace a ' at the beginning of a text cell using Replace Hilde Excel Discussion (Misc queries) 4 September 10th 07 06:22 PM
Replace dialog should put focus on "Find What" not "Replace With" Michael Williams Excel Discussion (Misc queries) 0 May 24th 06 12:45 PM
find and replace - replace data in rows to separated by commas msdker Excel Worksheet Functions 1 April 15th 06 01:00 AM
How can I use replace(alt+H) for mutiple items needing replace Gery Excel Worksheet Functions 1 June 15th 05 05:51 PM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"