I have done a lot of searching for this, and still can't find the right information..SampleList.xlsx
I have an auction site this is for. The site has subcategories for products. The purpose of this is so users can make an inventory on their machine that can be uploaded via a script I have. I need to make a subcategory dropdown that us dependent on the category dropdown I have. Also it needs to do more.
I have a drop down list in one column, column G that I have set the entire column to have, so I did not have to copy the function over and over. The second drop down, in column H needs to be dependent on the selection in column G. Now, the second column should have the formula apply to the entire column as well. The dropdown list in column g has illegal characters as well.
I need a special function to put in column H for the entire column that uses a lookup for the illegal characters. I found stuff on the internet explaining how to have illegal characters in a dropdown, but the formula did not explain how to apply to a whole column instead of a single cell. I do not want to copy and paste the formula to thousands of cells.
I don't know if this is possible, I have attached a workbook so you can see what I'm trying to do. The ranges for the subcategory lists are in a second sheet.
I tried to find a solution on the internet
Thanks,