Recalling a table conditionally (see inside)

[1tane1]

B2:N13 (2009)
B15:N26 (2010)
B28:N39 (2011)
B41:N52 (2012)

I have 4 tables in a sheet. You can see the ranges above. These tables give information based on the year they belong to.
In another sheet, I have a dropdown list of 2009-2012 (say in A1). Based on this selection (let's 2010) I want to insert the related table (to let's say B4:N15)
(Please remember some cells in the table are merged!)

[Special-K]

Maybe use INDIRECT with a VLOOKUP?

Alternatively I notice each table is 11 rows long so given a year, e.g. 2010
this formula will provide the range

"B"&(A1-2009)*13+2&":B"&(A1-2009)*13+13

where A1 is the year

[1tane1]

Thank you for the idea. I used this formula and it worked well:

Please Login or Register  to view this content.

I pasted the same formula to whole new table and the match one-one with the previous sheet.

I thought there could be an easier way. Such as define the table with a name and recall the table back.