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

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

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

then copy down.

Hope this helps.

Pete

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!

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!

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