STCrosstown
New Member
- Joined
- Aug 24, 2018
- Messages
- 9
So I am trying get a range to populate based on the selection in a single cell. So in the pic below, i have two types of projects. Admine Projects and IT Projects. They have different cost categories listed in column A and B. Cell D2 is a data validation where you can select either "Admine Projects, or IT_Project". I want the range F2:F13 to populate with the categories for the respective projects based on the selection in cell D2.
So when I select "Admine Projects" in cell D2 I would like the range F2:F13 to populate with the information in the range A2:A13.
How can i do this?
[/URL][/IMG]
So when I select "Admine Projects" in cell D2 I would like the range F2:F13 to populate with the information in the range A2:A13.
How can i do this?
![hYWtmi9.png](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22https%3A%2F%2Fimgur.com%2FhYWtmi9%22%5D%5BIMG%5Dhttp%3A%2F%2Fi.imgur.com%2FhYWtmi9.png&hash=a3f113aabeeb84fbc239c804b04cb9ed)