How to pickup value from a cell and populate next column
Kindly refer attached screenshot. Am trying to figure how does one populate the boxed column with the value in the cell (1,414). I am already able to do something by looking up a SYS table I constructed but the problem is I can't seem to figure out the right formula to use which should be to pick up the value 1,414 which corresponds to Rank 20 in the Rank column.
I like the idea but if am not wrong SELECT works with fixed parameters so if the number is not fixed at 20 it may not work? The number corresponds to number of accounts per selected country which varies from country to country. I am able to derive the number by indicating in a column the number of accounts I intend to modify. In the example given it was 20 but for another country, it may be a different number like 15. Given the above, is SELECT the right approach?
As you had said LOOKUP will work but am not sure how to do that within the same module or is the idea to have the number (say 20) picked up by a SYS module and to have a LOOKUP within the module referencing the SYS module for the value I need?