I have cell J11 with a drop down list which are 1,2,3,4. I need that:
1. When I choose 1, in cell c16 appears cell 'Tank 1'!E9
2. When I choose 2, in cell c16 appears cell 'Tank 2'!E9
3. When I choose 3, in cell c16 appears cell 'Tank 3'!E9
4. When I choose 4, in cell c16 appears cell 'Tank 4'!E9
Thanks
1. When I choose 1, in cell c16 appears cell 'Tank 1'!E9
2. When I choose 2, in cell c16 appears cell 'Tank 2'!E9
3. When I choose 3, in cell c16 appears cell 'Tank 3'!E9
4. When I choose 4, in cell c16 appears cell 'Tank 4'!E9
Thanks