Drop down list and find and place

Closed
Talahjer - Jan 26, 2011 at 02:49 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jan 27, 2011 at 05:48 AM
Hello, all

Is it possible to combine a find and insert with drop down list.
I mean A1 is drop down list which allows the user to enter T1 or T2 or T3 so when the user tries to enter any other word the excel returns false. I tried to add a formula in A1 that looks for a word in G1 and if it finds it, then the word is placed in A1 but the excel returns restricted and cannot be done. Is there a way to do what I am looking for.
Please if anyone knows how to solve this I would be really grateful.
Thanks in advance.


1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Jan 27, 2011 at 05:48 AM
your requirement is not completely clear

try this and see whether it is o;k

in T4 copy ths fomurl
=G1

now in A1 do validation and the list is T1 to T4
0