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

[wellinghall.livejournal.com]

A vlookup table?

[wellinghall.livejournal.com]

Like the one I've just sent you

[skordh.livejournal.com]

glad you did that as I can never remember how to do them

[wellinghall.livejournal.com]

I use them a lot at work.

[skordh.livejournal.com]

I use Excel a lot but VLookups only very occasionally. Which means that every time I use them I need to check how to do so!

[skordh.livejournal.com]

what he said