Excel help

%3CLINGO-SUB%20id%3D%22lingo-sub-2416683%22%20slang%3D%22en-US%22%3EExcel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416683%22%20slang%3D%22en-US%22%3E%3CP%3E1)%20I%20am%20creating%20a%20drop%20down%20list%20that%20will%20select%20an%20answer%20from%20a%20different%20tab%20(lets%20say%20these%20answers%20are%20in%20tab%202%20column%20c)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E2)however%20whatever%20answer%20is%20selected%20i%20then%20need%20to%20create%20a%20formula%20allowing%20to%20match%20the%20answer%20selected%20with%20the%20column%20next%20to%20it%20which%20includes%20a%20link%20(%20these%20links%20are%20in%20tab%202%20column%20f)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2416683%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2416746%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416746%22%20slang%3D%22en-US%22%3E%23urgenthelp%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2417270%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2417270%22%20slang%3D%22en-US%22%3EI%20have%20provided%20the%20question%20in%20a%20private%20message%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

1) I am creating a drop down list that will select an answer from a different tab (lets say these answers are in tab 2 column c)

 

2)however whatever answer is selected i then need to create a formula allowing to match the answer selected with the column next to it which includes a link ( these links are in tab 2 column f)

3 Replies
#urgenthelp

@meganpayne156 

If you mean select from C and after that from F you may google for "dependant for-down list", lot of samples. If not, better if you provide small sample file to illustrate the question.

I have provided the question in a private message