Hi All,
I am looking to have a value shown in cell D4 depending on a selected option from a drop down.
The dropdown is in cell B2 from a range listed in Q4 - Q10. each range in Q has a corresponding value in R4 - 10
So the end result will be on the dropdown is selected the Q6 then D4 will result will be the value in R6
I am looking to have a value shown in cell D4 depending on a selected option from a drop down.
The dropdown is in cell B2 from a range listed in Q4 - Q10. each range in Q has a corresponding value in R4 - 10
So the end result will be on the dropdown is selected the Q6 then D4 will result will be the value in R6