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

[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 :-)