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.
--
Kind regards
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
