# Replace number by text deppending of number

1. ## Replace number by text deppending of number

Hi everyone,

In sheet I send you what I would like is to know how to put a formula when I write in "J8...9..10...." a number it replace for the text corresponding in colluns O/P.

For example if I write in "J8" - "1" automatic it replace in "J8" for "Water"...

Miguel

2. ## Re: Replace number by text deppending of number

I dont think you can do it in the same cell.

to write something that will change itself in the same cell it is entered.

3. ## Re: Replace number by text deppending of number

Is there any possibility to do it in a simple way ????
For example if I write the number in Collun "I" to appear the text in "J" ???

4. ## Re: Replace number by text deppending of number

A vlookup..

I8=1
J8 = VLOOKUP(I8,\$O\$8:\$P\$12,2,0)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1