VLOOKUP with drop-down list · 2.Using the INDEX — MATCH function · 3.INDEX-MATCH for rows, Automatically fill cells according to. The Department is the third row, so the row number is 3 here. Now that you know how to create and apply Excel conditional formatting based on another cell, let's go ahead and see how to use several Excel formulas in practice. Anyone who has used Excel for some time knows how to use the autofill feature to automatically fill in an Excel cell based on another.
From what I've read, that's much more complicated than what I asked about and beyond my basic Excel skills, so instead of trying to become an Excel expert for this problem, I decided to give up. ExcelDemy is a place where you can learn Excel and get solutions to your Excel %26, problems related to VBA, data analysis with Excel, etc.