tag:blogger.com,1999:blog-5361417188517879449.post4740973214396477262..comments2023-10-24T18:59:56.584+08:00Comments on Game in the Brain: Stuck, looking for Spreadsheet functionsjustin aquinohttp://www.blogger.com/profile/03191474595831304520noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5361417188517879449.post-37012037117604290132011-08-23T20:14:35.004+08:002011-08-23T20:14:35.004+08:00Burnside to the rescue!
Ken's spreadsheets wi...Burnside to the rescue!<br /><br />Ken's spreadsheets will make your brain explode. :-)Dan Eastwoodhttps://www.blogger.com/profile/14105563883467108602noreply@blogger.comtag:blogger.com,1999:blog-5361417188517879449.post-57646639232048055632011-08-23T20:14:11.329+08:002011-08-23T20:14:11.329+08:00Burnside to the rescue!
Ken's spreadsheets wi...Burnside to the rescue!<br /><br />Ken's spreadsheets will make your brain explode. :-)Dan Eastwoodhttps://www.blogger.com/profile/14105563883467108602noreply@blogger.comtag:blogger.com,1999:blog-5361417188517879449.post-11073024442809753672011-08-20T11:02:00.761+08:002011-08-20T11:02:00.761+08:00Thanks DC and Ken!
It got me over my stump, and I...Thanks DC and Ken! <br />It got me over my stump, and I learned new spreadsheet tricks.justin aquinohttps://www.blogger.com/profile/03191474595831304520noreply@blogger.comtag:blogger.com,1999:blog-5361417188517879449.post-23660515768901305362011-08-19T21:31:18.010+08:002011-08-19T21:31:18.010+08:00First, what you should be doing for your array pro...First, what you should be doing for your array problem:<br /><br />VLOOKUP(Input_Value;Array_Name;Column;FALSE)<br /><br />Input_Value: What the user enters the match first column. It can be a cell reference, or better, a named cell.<br /><br />Array_Name: The range of cells defining the VLOOKUP function. This can also be a named range of cells. <br /><br />Column: The column of the table Ken Burnsidehttps://www.blogger.com/profile/18176106060717632571noreply@blogger.comtag:blogger.com,1999:blog-5361417188517879449.post-65905025581268310762011-08-19T21:27:40.307+08:002011-08-19T21:27:40.307+08:00As for the problem of referencing several arrays, ...As for the problem of referencing several arrays, I think this is possible, but it is *not* simple. A friend uses this for his own ship design spreadsheet. You might try posting a question in the Squadron Strike section at adastragames.com/discus.htmlDan Eastwoodhttps://www.blogger.com/profile/14105563883467108602noreply@blogger.comtag:blogger.com,1999:blog-5361417188517879449.post-66124581090031965252011-08-19T21:14:47.581+08:002011-08-19T21:14:47.581+08:00Are you using Open Office?
http://www.oooforum.org...Are you using Open Office?<br />http://www.oooforum.org/forum/viewtopic.phtml?t=55303Dan Eastwoodhttps://www.blogger.com/profile/14105563883467108602noreply@blogger.com