I need your assistance with drop down values.
I have sheet 5 with data. Columns A to H.
In sheet 1, C2. I created a drop down list from range Sheet5.A2 to A100.
The drop down works okay in Sheet1.
The question is, how can I automatically populate Sheet1.C3 with a value range from Sheet5.B2 to B100 based on the drop down value.