Hi,
Almost embarressed to ask, but it’s been a while since I’ve been doing this so it has slipped my mind… 
Got book “1” & “2”
Book 1 contains in Col A descriptive labels for annual accounting figures (col B onwards contain years, eg. B=2000, C=2001 etc…)
Book 2 – Cell C4 should show contents of Book 1 Cell B2, cell D4 should show Book 1 C2 etc..
In Book 2 col A, I type the number for the rows I want (eg. to get B2, col A shows ‘2’)
Thought I could do a simple:
1. concatenation like =CONCATENATE(‘[Book1.xls]Input’!B$,$A3)
2. ampersand ‘&’ like =”‘[Book1.xls]Input’!B$”&$A3
– but none of this seems to work, so please – refresh my mind 
THX in advance
