Using Index and Match and trying to avoid blank cells

[Shields]

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!