Forum Discussion
Excel autofill different texts
Please help me that if I want to add a code word in one cell, then how will a specific value related to code word will be entered in other cell.. Please help me
Forgive me if i am wrong but I think you are looking for the vlookup() formula.
You first create a list in a tabel like
A B
1 code value
2 1 one
3 2 two
4 test example
Then use that as a reference to that vlookup function
like
D
1 2 vlookup(D1,$A$1:$B$4,2,0) (Which will result in "two")
regards