+ Reply to Thread
Results 1 to 2 of 2

Select a Formula Based on Prior Selection

  1. #1
    Registered User
    Join Date
    09-01-2009
    Location
    Seattle, WA
    MS-Off Ver
    Office 365 / Office 2019
    Posts
    18

    Select a Formula Based on Prior Selection

    I am wondering if the following is possible, if so, how do I accomplish it.

    I am building a spreadsheet for calculating weights of metal pieces for miscellaneous metals production. This could be Stairs, Handrails, Guardrails, Equipment Decks, Bollards, etc.

    As an example a set of metal stairs will have multiple metal shapes involved in its construction.

    Depending on the metal shape, the weight either comes from a data table (I use VLOOKUP to get the weight/foot), in the description of the pieces (for example W16x31 is 31 lbs/lnft - I use RIGHT(K10,LEN(K10)-FIND("x",K10,1)) where K10 is the cell that would have the W16x31), or for bars and plates, I use the volume of the piece divided by its density.

    What I am wondering is if I can have a table that would have the name of the shape in column A and the formula I would use to calculate the weight of that shape in column B, then use a VLOOKUP in the cell I want the weight per foot to calculate to choose the appropriate formula.

    I am on Office 365 Version of Excel - I do not know how to change my office version
    Last edited by mmchaley; 11-05-2017 at 02:25 PM. Reason: added info

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,776

    Re: Select a Formula Based on Prior Selection

    Attach a sample workbook (not image).

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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-20-2016, 10:36 PM
  2. [SOLVED] Formula to get (Prior Biz Day) and (Prior Biz Day -1); ex-holidays
    By Phillycheese5 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2013, 09:29 AM
  3. [SOLVED] Select entire row based on data validation selection
    By mintymike in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2013, 03:14 AM
  4. [SOLVED] Select Sheet based on Combo box selection
    By Dave Herbert in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-04-2012, 04:08 AM
  5. Multiple selection criteria, which formula? .. and selection based on unique numbers
    By FalkirkJim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2012, 05:22 PM
  6. Select a sheet based on selection
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-26-2011, 07:09 AM
  7. Multi select Listbox Items selection based on other Listbox item selection.
    By srinivassathi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2011, 05:53 AM

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