Forum Discussion
making a formula from drop down list and reference from adjacent cell
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
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.
