Excel AKICOLJ
Feb. 6th, 2012 09:05 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
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'.
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'.
no subject
Date: 2012-02-06 09:18 pm (UTC)(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:no subject
Date: 2012-02-06 09:35 pm (UTC)=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".
(no subject)
From:(no subject)
From:(no subject)
From:no subject
Date: 2012-02-06 09:47 pm (UTC)no subject
Date: 2012-02-07 06:46 am (UTC)(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From: