Hey guys!
I'm just trying to implement the following function in my table:
The problem or the exciting is the area (XX: XX).PHP Code:
=ROUND(LOOKUP(RAND();XX:XX);1)
This range is dynamic and should be defined by the following start and end cell:
Start cell:
End cell:PHP Code:
="tblData!"&ADDRESS(22;(COLUMN((INDEX(tblData!2:2;MATCH(B1;tblData!2:2;0))))))
Combined, the following function should arise:PHP Code:
="tblData!"&ADDRESS(50;(COLUMN((INDEX(tblData!2:2;MATCH(B1;tblData!2:2;0)))))+1)
Unfortunately, this approach does not work. I get a message from Excel about an error, but not where it is.PHP Code:
=ROUND(LOOKUP(RAND();"tblData!"&ADDRESS(22;(COLUMN((INDEX(tblData!2:2;MATCH(B1;tblData!2:2;0)))))):"tblData!"&ADDRESS(50;(COLUMN((INDEX(tblData!2:2;MATCH(B1;tblData!2:2;0)))))+1));1)
Does anyone have an idea?
I hope my presentation with the words is enough.
Best regards
Bookmarks