jose11au
asked on
Populate other cells based on drop down value
Hi All,
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.
Thanks.
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.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You will get blank in C3 if the value selected in C2 on Sheet1 is not found in A2:A100 on Sheet5.
Are you sure that the value selected in C2 on Sheet1 is there on Sheet5 in the range A2:A100?
Are you sure that the value selected in C2 on Sheet1 is there on Sheet5 in the range A2:A100?
ASKER
Cool! Thanks. That works.
Thank you.
Thank you.
You're welcome Jose!
ASKER
I get a blank value with this
=IFERROR(VLOOKUP(C2,Sheet5
Any other suggestions?