How to pickup value from a cell and populate next column

ClarenceAndre
Regular Contributor

How to pickup value from a cell and populate next column

TAR02 Account Review showing cell to pickup and column to populate.jpg

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.

Any ideas much appreciated.

Kind regards,

Clarence 

 

 

10 REPLIES 10
ClarenceAndre
Regular Contributor

Thanks Chris for the reply, sounds bit complicated but let me work through the logic and see if I get it.