making a formula from drop down list and reference from adjacent cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1114928%22%20slang%3D%22en-US%22%3Emaking%20a%20formula%20from%20drop%20down%20list%20and%20reference%20from%20adjacent%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1114928%22%20slang%3D%22en-US%22%3E%3CP%3EVery%20much%20a%20newbie%20to%20this%20so%20bare%20with%20me.%3C%2FP%3E%3CP%3ETrying%20to%20create%20a%20formula%20in%20B5%20and%20B6.%20These%20will%20be%20dependent%20on%20what%20is%20selected%20from%20the%26nbsp%3B%20from%20a%20dropdown%20list%20B5%20is%20linked%20to%20B3%20and%20B6%20to%20B4.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20then%20depending%20on%20what%20is%20selected%20from%20the%20drop%20down%20list%20to%20corrolate%20to%20the%20sheet2%20column%20A%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20If%209.3%20is%20selected%20in%20the%20drop%20down%20on%20sheet1%20B3%2C%20then%20B5%20would%20%3D%20the%20relative%20%25%20in%20Column%20A%20of%20sheet%202%2C%20which%20would%20be%20sheet2%20A5.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1114928%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-1114952%22%20slang%3D%22en-US%22%3ERe%3A%20making%20a%20formula%20from%20drop%20down%20list%20and%20reference%20from%20adjacent%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1114952%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F522546%22%20target%3D%22_blank%22%3E%40Hosko%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20would%20be%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DINDEX(Sheet2!A%3AA%2CMATCH(Sheet1!B3%2CSheet2!B%3AB%2C0)%2C1)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E..%20in%20B5%20and%20copy%20it%20down%20to%20B6.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20workbook%20with%20the%20formulae%20in%20the%20green%20cells%20is%20attached.%20Let%20me%20know%20it%20this%20is%20what%20you%20expect%20to%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Very much a newbie to this so bare with me.

Trying to create a formula in B5 and B6. These will be dependent on what is selected from the  from a dropdown list B5 is linked to B3 and B6 to B4.

 

I then depending on what is selected from the drop down list to corrolate to the sheet2 column A list. 

 

Example: If 9.3 is selected in the drop down on sheet1 B3, then B5 would = the relative % in Column A of sheet 2, which would be sheet2 A5.

 

If this possible?

1 Reply

@Hosko 

That would be:

=INDEX(Sheet2!A:A,MATCH(Sheet1!B3,Sheet2!B:B,0),1)

.. in B5 and copy it down to B6.

 

Your workbook with the formulae in the green cells is attached. Let me know it this is what you expect to see.