Den 2011-02-17 20:15:00 skrev Wade Smart <[email protected]>:
On 02/17/2011 12:47 PM, Wade Smart wrote:
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
Ok. Got that working :D
Now, I have about 500 of these rows to do.
How do I get the lookup column to increase to each cell without
it offseting where its getting its data from?
If you hold the bottom right corner and drag, it will increase all the
cells by one in the function.
I just wrote about that a monite ago, hopefully you received it.
Good luck!
--
Kind regards
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
