Hello,
My spreadsheet is setup to where cell (B3) is a dropdown list consisted of 3 animals (DOG/CAT/FISH). In Columns F/G/H shows if that specific animal needs that item reflected by an “X”. I'm wanting to come up with a formula to where if you select each name on the dropdown, then Column A will automatically reflect the "X" or a "Blank" if that animal doesn't require it.
For instance, if DOG was selected in B3, then Column A would have the cells with an "X" such as in Column F. Additionally, if you select CAT in the dropdown in B3, the cells in Column A would reflect what has an "X" in Column G. Furthermore, if you select FISH in the dropdown in B3, the cells in Column A would reflect what has an "X" in Column H only.
Thank you in advance for the help!
My spreadsheet is setup to where cell (B3) is a dropdown list consisted of 3 animals (DOG/CAT/FISH). In Columns F/G/H shows if that specific animal needs that item reflected by an “X”. I'm wanting to come up with a formula to where if you select each name on the dropdown, then Column A will automatically reflect the "X" or a "Blank" if that animal doesn't require it.
For instance, if DOG was selected in B3, then Column A would have the cells with an "X" such as in Column F. Additionally, if you select CAT in the dropdown in B3, the cells in Column A would reflect what has an "X" in Column G. Furthermore, if you select FISH in the dropdown in B3, the cells in Column A would reflect what has an "X" in Column H only.
Thank you in advance for the help!