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

Copper Contributor

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.