I am looking for a formula who can do auto fill a cell of another sheet if a certain column is inserted, i.e
Column A inserted text by means of drop down. Of each particular text column C will be automatically filled linked on that particular text. I have a list of 40 different text (in Column A) which are categorized in 6 group and one of this group needs to be filled in Column C.
Example: Column A contains text1, text2, text3, text4.. upto text40. These are catergorized in textA, TextB, textC, textD. Text1 upto text4 is in catergory TextA and text5 upto text10 is in catergory TextB etc.