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 -- 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]
