I was fortunate to get help from this forum for my dependent drop down menu problem. The formula worked perfectly. But as usual when the customer gets what they ask for then they ask for something else. Here is the formula I got to satisfy my dependent drop down cell problem: =OFFSET(INDEX(Product,MATCH($E$19,Product,0)),22,,COUNTA(INDEX(Device_Type,0,MATCH($E$19,Product,0))),1). Works great. Now the customer wants this same validation for 2 other cells. The list of choices they can select for Device Role is dependent on what they choose for a Device Type. I thought I understood what this formula was doing but I guess I didn't because I "tweaked" it as follows: =OFFSET(INDEX(DeviceType,MATCH($G$19,DeviceType,0)),56,,COUNTA(INDEX(DeviceRole,0,MATCH($G$19,DeviceType,0))),1) and I get a blank value.
Don’t have an account yet? Register yourself now and be a part of our community!