electrichi01
New Member
- Joined
- Aug 10, 2009
- Messages
- 44
Hello
Here is what I am trying to do, perhaps someone can guide me?
Cell A1 is a drop down list to choose between 2 options- Cats or Dogs. whichever you choose will drive the answers below.
If you choose either one- Cats or Dogs, it pulls data from other cells and populates cells A2 and A3 with specific quantities of Cats and Dogs.
Cell A2 is- if it is Cats, then a certain #of Cats
Cell A3 is- if it is Dogs, then a certain # of Dogs
Cell A4 is- If cell A1 is Cats, then grab data from cell A2, If cell A1 is Dogs, grab cell data from A3.
Thanks for your help~
Here is what I am trying to do, perhaps someone can guide me?
Cell A1 is a drop down list to choose between 2 options- Cats or Dogs. whichever you choose will drive the answers below.
If you choose either one- Cats or Dogs, it pulls data from other cells and populates cells A2 and A3 with specific quantities of Cats and Dogs.
Cell A2 is- if it is Cats, then a certain #of Cats
Cell A3 is- if it is Dogs, then a certain # of Dogs
Cell A4 is- If cell A1 is Cats, then grab data from cell A2, If cell A1 is Dogs, grab cell data from A3.
Thanks for your help~