#VALUE! when using defined name

[WAMTC]

HELP!!!
Problem: receive #VALUE! Using a defined NAME range
In workbook MonthlyBudget09Mstr.xlsx are sheets 1209Sch and 1209
1209Sch contains all monthly entries, 1209 is the summary sheet.

Defined name: HousingItems, ='1209Sch'!$L$83:$L$88, Values:
{"1";"2";"3";"4";"5";"15"} Workbook <<from Name Manager
L88 is a SUM function but I have remove L88 from range and still have problem

Placing =HousingItems in cell B4 of sheet 1209 results in #VALUE! Error
B4:B9 are empty

Can copy and then paste 1209Sch L83:L88 into B4 which fills B4:B9 with
correct values.

Please advise what I am doing wrong
Thanks
Rick

 

[T. Valko]

HousingItems is an *array* so you'd have to select a range of cells the same
size as HousingItems then array enter.

If you're just doing a simple cell link try this in B4 then copy down as
needed:

=INDEX(HousingItems,ROWS(B$4:B4))

 

[WAMTC]

Biff
Thxs it worked and I understand to way it works.
Rick

 

[T. Valko]

You're welcome. Thanks for the feedback!