Excel Function -Address

[joshua1990]

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?