I thought that everything was in 1 column and you wanted to split off the "1" or "2" from column 1 into it's own colum. Hello, I need to know how to auto-fill text based on text in another cell. Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells. Drag the fill handle . Auto fill cells based on the data in another cell I am not experienced enough with formulas to figure this out: My problem is I would like to have a sheet that if I type (or use drop down) a teacher's name, in another cell his/her code number (15 digits) would automatically fill. For example: Every time I enter "CHS" in Column B, I want Charleston to auto-fill in Column C. And when I enter "SAN", in Column B, I want San Diego to auto-fill in Column C. This post will guide you how to create a drop down list and how to auto fill cells in Excel based on a dependent drop down list. Re: Auto Populating a cell based on values from another cell. Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 More... Less. Excel 2007 Posts 3. I have all the data I need in another table. When selecting value in the drop down list, you want the corresponding values in range B2:B8 to be automatically populated in a specific cell. I want to fill in one cell with text based on another cell that has a number. Hi, Need some help to make my life a little bit easier: I'm making plans for a production facility, and I want to autofill all the cells based on product number. Let’s say you have created a drop down list based on values in range A2:A8. Is there a way to auto fill a cell in an excel sheet based on a data entry in another cell? Note: ... For the series 2, 2, 2, 2..., type 2 in first cell only. In my case I have multiple possible criteria, B1 = Correct is just ONE example. Here is what I want to do: Suppose I have two columns in my sheet (A,B).I want the column B to show data based on a data range in the column A, for example if the value entered is between 0 and 20 I want to the column B to show Bad, and if the value entered is between 21 and 60 I want B to show OK etc. You have defined values in column A with AT LEAST the following possible entries: Okay, thanks for the example. Let me see if I've got this straight. When selecting a value from the drop down list, then it should be able to populate the value in another corresponding cell. So for example if A1 reads 2 I want B1 to read Correct. How to auto populate other cells when selecting values in Excel drop down list?