Results 1 to 6 of 6

Populating # values based on multiple text answers

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2015
    Location
    Michigan, US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Populating # values based on multiple text answers

    Hi everyone! I am posting this again because I posted it before, but didn't explain it very well and someone suggested I add a dummy worksheet along with it so here I am again!

    Okay, so the company I work for has just switched over to a new company with different policies and procedures. Our old company had global policies and procedures and this one does not, meaning that every different part requires different case of documentation. Ex: If you are buying from China and shipping to Mexico there are different documents than buying from China and shipping to US, whereas before it was all the same document just translated into different languages. That being said there are five questions that will need to be answered in order to find out what three documents will need to be used. The answers to the questions will be drop down selections, and text format. The results or answers I want them to populate (the documents) will be numeric values.

    Again I attached a dummy document, this is not how the format needs to be. Ex: if you think it's easier to list out all the documents and have a value saying yes or no next to it that is fine! Preferred being that they answer all the questions and it populates itself.

    Also one last thing: I am leaving this company next week but am trying to finish this up for them. Obviously I am willing to work with any solution but the easier it can be explained to the person that is taking over my position the better. Also I am pretty new to excel, so I am willing to learn anything but please explain it in layman's terms (as best as possible) haha. THANK YOU SO MUCH!!!! this is really appreciated(:
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Populating Multiple Results based on multiple answers
    By g_francescal in forum Excel General
    Replies: 2
    Last Post: 08-05-2015, 10:49 AM
  2. Replies: 4
    Last Post: 05-19-2015, 11:53 PM
  3. Excel 2007 : Sum values for multiple answers
    By martin_84 in forum Excel General
    Replies: 4
    Last Post: 04-12-2012, 04:07 AM
  4. IF to return multiple text answers depending on value in cell
    By CKD777 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-14-2011, 06:54 PM
  5. Populating ListBox with answers from equations
    By peedarp1985 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2010, 12:54 PM
  6. Get multiple answers depending on other text
    By P357 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2008, 10:44 PM
  7. [SOLVED] Can VLOOKUP return multiple answers based on several identical lo.
    By jddtct in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2005, 03:06 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