+ Reply to Thread
Results 1 to 2 of 2

use info in one cell to pull info to another cell

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    use info in one cell to pull info to another cell

    I am trying to create a variable labor rate estimate sheet. The labor amount is different for various times. for instance i want to have a formula in A3 that will bring up an answer in B3. so if i type in 1.2 in A3 that amount will show up in B3 as $130.00 without having to type that amount into the cell. if for instance i wanted to type in A3 2.3 that would bring up $290.00, and so on. hope someone can help. i can't bang my head on the desk anymore, it is starting to hurt.

  2. #2
    Registered User
    Join Date
    09-20-2012
    Location
    Utrecht, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: use info in one cell to pull info to another cell

    You could do a search function: see attached file. I don't know how you calculate labor cost though... I hope you have a formula you can use for that!
    Good luck, let me know if this helps.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1