I have an issue in Excel. Here is what i am trying to do, is this possible?
In a control I have a selection formula something like =$A$1:$A$500...so now I am limiting the "lookup" to 500 values. What happens if there is 501?
So here is my question...
Can I create a formula that makes that 500 = to a cell value, for instance: =$A$1:$A$(X) Where X would be equal to a cell value, so I can make this lookup in the control dynamic? I want X = the cell value of B1.
Is this possible??