Drop down menu-import layout

Hello-

I have an excel template we use to import product data into one of our systems. I need to find the correct "formula" that would allow us to select from a drop in one sheet, the correct category and then automatically update the cell next to it with the categories correct "ID". All of our categories and category ID's are in the same workbook but in a different sheet. We can use the drop down now, which shows all the categories in the sheet, but it will not include the category ID. I tried to attach our import book but no luck.


The "import layout" sheet includes the "category ID" and "category" headers. The category column has a drop down which is derived from sheet "categories". In sheet "categories" you see the actual category listing and in the adjoining cell, it's corresponding "ID".

When the correct category is selected on the importlayout sheet, the corresponding (and correct) category ID needs to populate the "category ID" cell.

How do I do this?

Hello Mikeyy,

Welcome to the Forum!

Sometimes it is difficult to upload files workbook files to the forum due to various reasons. When this happens, you can try to upload the workbook again, or you can zip it and then upload it. I have had more consistent results posting zipped files. Give it try.

Sincerely,
Leith Rross

Lets try a zip then-

Hello Mikeyy,

Have a look at the link below. After looking at your workbook, I think this approach will work for you.

Excel -- Data Validation -- Create Dependent Lists

Sincerely,
Leith Ross

Thanks. I read through it a couple of times and see where it may work. I got sidetracked on the dependant area as my data is in a different sheet. The example seems to refer to the source data being in the same sheet.

Okay...I took a look at this and don't see where it will accomplish what I need. I have data in two separate sheets. This example does not address that. I did do some other exploring and I don't think this formula will work. It appears this is designed to pull a drop down list based on an entry....I need it to pull one cell based on an entry.