+ Reply to Thread
Results 1 to 8 of 8

Copy correct multiple choice answer into field based on number 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 field based on number identifier

    I have a set of 4 multiple choice answers B,C,D,E column "F" lists a # 1-4 which lets you know which column letter (b,c,d,e) the correct answer is in. I want to set up a formula that will copy the contents of the correct answer (based on that # identifier) and copy it into column "A" which is currently blank

  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,898

    Re: Copy correct multiple choice answer into field based on number identifier

    Try this in row 2 (assuming you have a header row):

    =INDEX($B2:$E2,$F2)

    then copy down.

    Hope this helps.

    Pete

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

    Re: Copy correct multiple choice answer into field based on number identifier

    Sorry but that didn't work.

    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!

  4. #4
    Forum Guru 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 field based on number identifier

    Pete's suggestion should work. What result did you get?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

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

    Re: Copy correct multiple choice answer into field based on number identifier

    I'm getting #ref! error saying its out of range here is what i have =INDEX($F52:$I52,$J52)with Row E52 having the field i want to have the result posted in, F,H,G,I have the 4 answers and J has the # that lets you know which answer i.e FHGI to place. Thanks!

  6. #6
    Forum Guru 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 field based on number identifier

    Works for me.

    Data Range
    E
    F
    G
    H
    I
    J
    50
    ------
    ------
    ------
    ------
    ------
    ------
    51
    52
    Dean Martin
    Frank Sinatra
    Sammy Davis
    Dean Martin
    Joey Bishop
    3
    53
    54


    This formula entered in E52:

    =INDEX(F52:I52,J52)

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

    Re: Copy correct multiple choice answer into field based on number identifier

    It worked in EXCEL but for some reason not in google docs, thank you guys so much!

  8. #8
    Forum Guru 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 field based on number identifier

    Have no experience with Google Docs.

    There is a forum dedicated to other platforms:

    http://www.excelforum.com/for-other-...mobile-os-etc/

+ 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. multiple choice answer
    By Getfothers in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2014, 09:54 AM
  2. [SOLVED] Matching emails based upon number identifier
    By Meltom in forum Excel General
    Replies: 6
    Last Post: 10-02-2013, 11:35 PM
  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. 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