Hello Everyone,

I have a worksheet (Cost Center) with a dropdown menu and column that I'm trying to populate with a list of items from worksheet (DataPMC) based on the selection from the dropdown. Can't use Vlookup because it runs horizontally. Here is what I have so far wasn't sure if I needed to code the worksheet in VBA or if someone has a solution for me.

=OFFSET(DataPMC!A1,1,1)
Thanks I attached the worksheet

Project Managment Center.xlsm