Excel AKICOLJ

[philmophlegm]

How do I do this in Excel?

I want to enter a value in the range 0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F (or similar) in one cell, and then in another cell show the entry from a table that corresponds to this value.

For example, I want to enter the value 'B' in the 'Atmosphere' column and then have my spreadsheet show in the next cell that Atmosphere B is 'Corrosive'. If I had put in '5', it would show 'Thin'.

Comments

[king-pellinor.livejournal.com]

Actually, you could fudge it fairly easily. Give every jump route a number, and say which routes each world is on. The effective demand for each good on each world could then factor in the supply of that good from all worlds with the same jump route number, to reflect the fact that demand is almost certainly being met to a large extent.

[philmophlegm.livejournal.com]

That sounds like a very good way to fudge it. Actually, that sounds sensible enough that I wouldn't call it a fudge. Your fundamental point about taking into account the characteristics of nearby systems is a very good one - in fact, it's one of the things I wasn't satisfied with in any of the existing systems. I reckon it could be done with clever Excel formulae and tables rather than having to use anything fancier, regardless of my what my SQL-using wife might think...

[king-pellinor.livejournal.com]

I think that once you start getting into lots of tables, then something that works in more than Excel's two dimensions starts to become increasingly attractive :-)