Closed Thread
Results 1 to 3 of 3

Copy correct multiple choice answer into blank field based on corresponding # identifier

  1. #1
    Registered User
    Join Date
    03-23-2014
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010 Mac
    Posts
    7

    Copy correct multiple choice answer into blank field based on corresponding # identifier

    Here's an example of what i want to do

    A_________ B Frank Sinatra C Sammy Davis D Dean Martin E Joey Bishop F 3

    I want to put "D"'s value 'Dean Martin' in column A - i know it belongs in A because the "3" in column F indicates its the 3rd answer listed i.e Dean Martin. This format would be the same where there are 4 possible answers on the column to the right dictates which answer is correct. Thanks for your help!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Copy correct multiple choice answer into blank field based on corresponding # identifi

    See your other thread.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Copy correct multiple choice answer into blank field based on corresponding # identifi

    This thread seems to be the same as your other thread....
    http://www.excelforum.com/excel-form...dentifier.html

    I am closing this thread now, you can continue on the other 1. If you think I am in error here, PM me and explain what the difference is?

    Thanks
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 03-24-2014, 09:12 AM
  2. multiple choice answer
    By Getfothers in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2014, 09:54 AM
  3. if the correct answer is given copy question to different sheet
    By moley165 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-10-2013, 05:01 AM
  4. A formula that sums & indexes multiple arrays based on identifier?
    By Rakib79 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-31-2012, 02:07 PM
  5. [SOLVED] how do u set up multiple choice answer buttons/dots?
    By pam123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-01-2006, 08:48 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