In cell J8 list of codes (thru data validation) and L8 will show resolution (TOP/BOTTOM) (by vlookup formula). I had added the "Others" on the data validation list and added dependent drop list of top or bottom will be shown. The problem when i have the parent after "Others" chosen, I can clear the dependent drop down with vba but i need remain the vlookup formula. How?
Bookmarks