Data Validation Basis Another Cell Inputs
I have a simple sheet. Column A contains inputs that can be A, B C, D, E. The inputs are a drop down list. Column B inputs need to be restricted basis the input in Column A. So if A1 =A, B1 should have an input of the range100-12%,
If A1=B, B1 should have an input 120-140% and so on. Given the inputs in Column A can be dynamic and any of the 5 drop down values how do we restrict values in Column B dynamically to correspond to the input in Column A
I have a simple sheet. Column A contains inputs that can be A, B C, D, E. The inputs are a drop down list. Column B inputs need to be restricted basis the input in Column A. So if A1 =A, B1 should have an input of the range100-12%,If A1=B, B1 should have an input 120-140% and so on. Given the inputs in Column A can be dynamic and any of the 5 drop down values how do we restrict values in Column B dynamically to correspond to the input in Column A Read More
