philmophlegm: (Traveller Book)
[personal profile] 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'.

Date: 2012-02-06 09:35 pm (UTC)
andrewducker: (Default)
From: [personal profile] andrewducker
Yeah, a VLookup. If you have your values from A1->A10 and the things you want to lookup in B1->B10 and the location of the value to lookup is in D1 then you want:
=VLOOKUP(D1,A1:B10,2,FALSE)

The "2" is the column of the answer, and the "FALSE" says "Don't look for an approximate match, give me an exact one".

Date: 2012-02-06 09:47 pm (UTC)
From: [identity profile] philmophlegm.livejournal.com
Excellent - thanks all.

Date: 2012-02-07 06:46 am (UTC)
From: [identity profile] foradan.livejournal.com
Is that a Traveller world generator in a spreadsheet?

Profile

philmophlegm: (Default)
philmophlegm

March 2017

S M T W T F S
   1234
56 7891011
12131415161718
19202122232425
262728293031 

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jun. 13th, 2025 01:15 am
Powered by Dreamwidth Studios