Hi All,
If i have 5 names like apple,boy,cat,dog,energy
and if i enter a in a cell it should output apple in the same cell.
example: (=IF(A1="a",A1=apple,0))
can anyone tell me how to do this,
Thanks in advance,
Akay
Hi All,
If i have 5 names like apple,boy,cat,dog,energy
and if i enter a in a cell it should output apple in the same cell.
example: (=IF(A1="a",A1=apple,0))
can anyone tell me how to do this,
Thanks in advance,
Akay
You could do list data validation for the other cell off A1:Ax
i think..
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
You could do list data validation for the other cell off A1:Ax
i think..
You can use Excel AutoCorrect options
Third option - you could create a worksheet_Change routine that checks for the values you want and changes the cell value if required.
Wont the change trigger the change event again though?
It shouldn't if you turn the EnableEvents to off before you do the change and back on after you are done.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks