When I enter in a #, I want it to enter in the text instead of the number.
For example: 1=Corp; 3=BPGS; 5=Rodney. I want this to apply to an entire
column so that I can just go down, enter in the number and the word will
enter in.
Pls help
When I enter in a #, I want it to enter in the text instead of the number.
For example: 1=Corp; 3=BPGS; 5=Rodney. I want this to apply to an entire
column so that I can just go down, enter in the number and the word will
enter in.
Pls help
Hi Candy
Assuming you put a list of your numbers and names on Sheet2, in columns
A and B e.g
1 Corps
2 Something else
3 BPGS
etc.
Then on Sheet1 in cell B1 enter
=VLOOKUP(A1,Sheet2!$A$1:$B$100,2,0)
changing the range to include the last row you have entered data.
Copy this down column B then as you enter any number in column A, the
corresponding name will appear in column B.
Regards
Roger Govier
Candy wrote:
>When I enter in a #, I want it to enter in the text instead of the number.
>For example: 1=Corp; 3=BPGS; 5=Rodney. I want this to apply to an entire
>column so that I can just go down, enter in the number and the word will
>enter in.
>
>Pls help
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks