Google Spreadsheet formula

Copper Contributor

I need a formula for my google spreadsheet. 

I have a drop down list with "Dog", "Cat", "Rat" and "Bat". If I am selecting "Dog" in the next column I would like to get another drop down list which is related to "dog" - "Kennel", "Choke chain", "Puppy Pedigree".  

I requesting the equation for the same... Please help me...

Thank you

1 Reply

@nikhilnarayanan3553 You are posting to an MS Excel forum. Better to ask you question in the Google Sheets help community.