Hi guys, Im looking for a formula that can add a cell position and use its value in a result. Im trying to input 20 unique cells of data (Column A) into (column B) for every series of 11111-11114 (There are 20 series)
so far I have in B2: =IF(COUNTIF($C$1:C2,11111)>COUNTIF($C$1:C1,11111),CELL("content",$A$1:$A$20),B1)

I am unable to get around the automatic positioning of cell content range. I tried adding and subtracting 1 but it just performs the calculation as if it were a value not a cell position. But it just ends up with every 4th postion of column A.

I know that it can be done with a reference numbers and doing a vlookup but due to the nature of the data Im working with, its much more of a hassle to input a reference, and deleting it afterwards.

Any thoughts?



A B C
101 101 11111
203 101 11112
501 101 11113
212 101 11114
353 353 11111
654 353 11112
618 353 11113
111 353 11114
941 941 11111
314 941 11112
516 941 11113
418 941 11114
888 888 11111
999 888 11112
456 888 11113
123 888 11114
789 789 11111
741 789 11112
852 789 11113
963 789 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114
#VALUE! 11111
#VALUE! 11112
#VALUE! 11113
#VALUE! 11114