Need formula

[noelmus]

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

 

[jtakw]

Hi,

Try this:

=CHOOSE(J11,'Tank 1'!E9,'Tank 2'!E9,'Tank 3'!E9,'Tank 4'!E9)

 

[noelmus]

Hi jtakw,
Perfect
Thanks

 

[jtakw]

You're welcome.