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...
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.