joshua1990
08-02-2017, 04:13 AM
Hey guys
!
Although it is not a VBA code, but maybe can help me Yes nonetheless.
I want to perform the following function:
=ROUND(LOOKUP(RAND(); ADDRESS (22) (COLUMN ((INDEX(tblData!2:2;))) MATCH(B1;tblData!2:2;0))):address(50;(column((index(tblData!2:2; MATCH(B1;tblData!2:2;0)))+1));1)
Unfortunately, I get the error that the function contains an error. I think this is the area ADDRESS: ADDRESS.
The formula are in the original condition as:
=ROUND(LOOKUP(RAND(); initalcell: end cell; 1).
The initial cell is determined as follows:
ADDRESS (22) (COLUMN ((INDEX(tblData!2:2;))) MATCH (B1;tblData!2:2;0)))
The end cell according to the same logic.
How do I clean the addresses of both cells now in my function?
!
Although it is not a VBA code, but maybe can help me Yes nonetheless.
I want to perform the following function:
=ROUND(LOOKUP(RAND(); ADDRESS (22) (COLUMN ((INDEX(tblData!2:2;))) MATCH(B1;tblData!2:2;0))):address(50;(column((index(tblData!2:2; MATCH(B1;tblData!2:2;0)))+1));1)
Unfortunately, I get the error that the function contains an error. I think this is the area ADDRESS: ADDRESS.
The formula are in the original condition as:
=ROUND(LOOKUP(RAND(); initalcell: end cell; 1).
The initial cell is determined as follows:
ADDRESS (22) (COLUMN ((INDEX(tblData!2:2;))) MATCH (B1;tblData!2:2;0)))
The end cell according to the same logic.
How do I clean the addresses of both cells now in my function?