Assign a number to a text string.

[jimleslie77]

In an excel spread sheet if I type in the word "work" in col a row b, can that automatically assign the number "8" to col b row b. If so how do I do this?

Thanks
Jim

 

[NBVC]

Like this?

in B2, enter =IF(A2="work",8,"")

 

[Oaktree]

Welcome to the board.

Not to sure what you mean by

col a row b

, but try setting B1 = IF(A1="Work",8,"") and copying the formula down.

 

[Richard Schollar]

Hi Jim

Welcome to the Board!

Just to expand on NBVC's suggestion, if you have multiple possibilities ie Work=8, Play=6, Hiking=10 etc then you might like to use VLOOKUP instead. Eg in B2:

=VLOOKUP(A2,$D$1:$E$3,2,0)

Where D1:D3 holds Work, Play, Hiking and E1:E3 holds 8,6,10.

Best regards

Richard

 

[jimleslie77]

Ive been trying for ages to get this sorted, thanks so much to you all for all your help.