+ Reply to Thread
Results 1 to 3 of 3

Create formula from a cell selected from drop down box.

  1. #1
    Registered User
    Join Date
    05-04-2010
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Create formula from a cell selected from drop down box.

    Hello,

    I am hoping one of you clever folk can help me out. I was wondering if it was possible to create a formula based on what selection I make from my drop down list?

    costings.png

    What I would like to happen is, because I have selected Sea View in cell B5 from my dropdown list, then cell G5 would automatically know to times the hours (f5) by 14 which is what is charged for sea view per hour.

    Then if I select something else in B5 it would automatically re calculate for the cost that property and so on and so forth. So I can see quickly and easily without too much data input my costings for each job.

    I suppose I was hoping I could give each location a hidden figure that would only get used once selected. Was just trying to do a simple spreadsheet ha ha to work out cost compared to location depending on staff etc.

    I do apologise if I make no sense at all in what I am after and trying to achieve.

    Thanks for reading and thanks for any help

    Bluedusty

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,146

    Re: Create formula from a cell selected from drop down box.

    If you set up a table somewhere that lists all the contract types in one column and the appropriate rate in the next column, then you would be able to use a VLOOKUP formula.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    05-04-2010
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2003
    Posts
    2
    Quote Originally Posted by Pete_UK View Post
    If you set up a table somewhere that lists all the contract types in one column and the appropriate rate in the next column, then you would be able to use a VLOOKUP formula.

    Hope this helps.

    Pete
    Thanks Pete this worked a treat, sorry for my late reply

    SOLVED

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-21-2019, 01:21 AM
  2. Replies: 5
    Last Post: 09-26-2016, 07:40 AM
  3. Replies: 1
    Last Post: 03-10-2016, 10:39 AM
  4. Replies: 12
    Last Post: 10-29-2013, 01:13 AM
  5. Replies: 4
    Last Post: 10-12-2013, 01:01 PM
  6. [SOLVED] Create a Drop-Down List of Delmited Text within a selected Cell
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2013, 05:51 PM
  7. how to create a drop down list that will populate multiple cells after selected
    By aaronriggle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2012, 06:59 PM

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