Can I type text in one cell and have a value auto-enter in 2nd cel
You could use VLOOKUP. Set up a table, such as
A B
1 Green 2
2 Brown 3
3 Red 2
Then let's say you enter "Green" in cell D1, in E1 enter
=VLOOKUP(D1,$A$1:$B$3, 2, 0)
and copy down column E as far as needed.
"IowaTBone" wrote:
What I would like to accomplish is that if I enter a certain word or phrase
in a cell, I want a pre-determined number to automatically enter into another
cell. For example...if I type "Green" into one cell I want the number "2" to
be automatically enter into another cell in the same row. For this specific
task, I will be entering any of 30 different words that correspond to 10
different numbers, but will be doing this almost a thousand times throughout
the spreadsheet....the ability to have the number auto-entered would be a
great time saver. Any advice would be greatly appreciated.
|