On 02/17/2011 09:43 AM, Johnny Rosenberg wrote:
Den 2011-02-17 14:35:47 skrev Wade Smart <[email protected]>:
I have a column that will have 10 possible words in it.
Each word is assigned a number.
I have another column which calculate those words based on the numbers.
So, A1 is (Beginner, Recreational, Highschool, College, Experienced,
etc). Beginner = 1, Rec = 2 etc.
So in say B1 I want it to say 2 if I write Rec.
I was trying nested IFs but thats very complex.
Any ideas?
Wade
I would have made a list on a new sheet with two columns, like this:
Beginner 1
Recreational 2
and so on.
Then, on the first sheet, I would have used VLOOKUP() in column B.
Ok so in F2 I have "Rec", or will have as each cell is filled in, and in
G2 it needs to red "2".
L2 = Beginner
M2 = 1
L3 = Rec
M3 = 2
So if I want G to have a number in it from what I write in F, I put the
lookup in G2.
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
