Hi all,
I am currently developing a terrain generation system for gaming.
I am using Index and Match combined to determine the 'features' in a given zone of the board. The problem I am running into is that the array I am calling on has blank cells and when a blank cell is returned I get a 0 where I would like excel to try again. Otherwise this works perfectly.
I am sure this is more doable in VBA but I'd like to avoid that if possible and this is the only stumbling block I've hit.
Here is the current iteration: =IF($B$24>1,(INDEX('Asset Listing'!A1:E24,RANDBETWEEN(1,23),MATCH(Formula!$B$2,'Asset Listing'!$A$1:$E$1,0))),"None")
Thanks!
I am currently developing a terrain generation system for gaming.
I am using Index and Match combined to determine the 'features' in a given zone of the board. The problem I am running into is that the array I am calling on has blank cells and when a blank cell is returned I get a 0 where I would like excel to try again. Otherwise this works perfectly.
I am sure this is more doable in VBA but I'd like to avoid that if possible and this is the only stumbling block I've hit.
Here is the current iteration: =IF($B$24>1,(INDEX('Asset Listing'!A1:E24,RANDBETWEEN(1,23),MATCH(Formula!$B$2,'Asset Listing'!$A$1:$E$1,0))),"None")
Thanks!
