tag:blogger.com,1999:blog-4134750084087927747.post2999954424249918118..comments2014-12-20T22:09:57.199-07:00Comments on Ode to Black Dougal: Wilderness Hex StockingP_Armstronghttp://www.blogger.com/profile/12374589162025099763noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-4134750084087927747.post-25111498616013660892013-03-19T20:35:54.076-06:002013-03-19T20:35:54.076-06:00Sorry, I don't know what would be causing that...Sorry, I don't know what would be causing that.<br /><br />So long as the "$A$1:$B$6" references the table, the randbetween should generate a number from 1 to 6 and the vlookup should look up the random number in the first column of the table and return the corresponding result from the second column.P_Armstronghttp://www.blogger.com/profile/12374589162025099763noreply@blogger.comtag:blogger.com,1999:blog-4134750084087927747.post-43781474876430714472013-03-14T14:03:38.640-06:002013-03-14T14:03:38.640-06:00Aye the randbetween bit works fine on its own, but...Aye the randbetween bit works fine on its own, but when combined with vlookup, it doesn't do owt but error?damian breenhttp://www.blogger.com/profile/10220677886812081890noreply@blogger.comtag:blogger.com,1999:blog-4134750084087927747.post-29164884884997799442013-03-11T20:30:27.463-06:002013-03-11T20:30:27.463-06:00if you put:
=randbetween(1,6)
into a cell, will it...if you put:<br />=randbetween(1,6)<br />into a cell, will it give you a number?P_Armstronghttp://www.blogger.com/profile/12374589162025099763noreply@blogger.comtag:blogger.com,1999:blog-4134750084087927747.post-3140875484619963322013-03-11T14:43:16.473-06:002013-03-11T14:43:16.473-06:00Thanks for the idea, it certainly will make hex st...Thanks for the idea, it certainly will make hex stocking easier if I get the formula to work. I keep getting an NA error in the target cell and when I run help its the randbetween that is causing the error? how do I change the number it looks up into text monster/special etc in the new cell?damian breenhttp://www.blogger.com/profile/10220677886812081890noreply@blogger.comtag:blogger.com,1999:blog-4134750084087927747.post-82745111750722496632013-03-10T11:57:07.258-06:002013-03-10T11:57:07.258-06:00Beautiful, thanks very much for sharing! I think I...Beautiful, thanks very much for sharing! I think I see an entire hexploration spread sheet construction in the near future!Fenway5http://www.blogger.com/profile/14870312188585916750noreply@blogger.comtag:blogger.com,1999:blog-4134750084087927747.post-76636226393593924032013-03-10T11:24:43.444-06:002013-03-10T11:24:43.444-06:00Cells A1 to B6 put a version of the table on page ...Cells A1 to B6 put a version of the table on page B52 so it looks sort of like this:<br /><br />1 | Monster<br />2 | Monster<br />3 | Trap/Obstacle<br />4 | Special<br />5 | Empty<br />6 | Empty<br /><br />Then in all of the cells that represent you hexes put the formula:<br />=vlookup(randbetween(1,6),$A$1:$B$6,2,false)<br /><br />That should do it.P_Armstronghttp://www.blogger.com/profile/12374589162025099763noreply@blogger.comtag:blogger.com,1999:blog-4134750084087927747.post-16897938609080475812013-03-10T10:39:10.563-06:002013-03-10T10:39:10.563-06:00Great tool! Can you share the Spread sheet or the...Great tool! Can you share the Spread sheet or the Vlook formula?Fenway5http://www.blogger.com/profile/14870312188585916750noreply@blogger.com