Re: convert cell value into name either to call a tab or a named array

Dip_Bou You can do this using the INDIRECT function, but I recommend that you first reconsider your design. The way your data is spread across more than one worksheet makes your Excel work unnecessarily complicated. If all were on a single tab in a single table, it would be very easy to summarize your data.

The INDIRECT formula would look like this (the single quotes are needed because sheet names might contain spaces):

=INDIRECT("'"&A10&"'!B14")