Hello folks,

I am quite confused by the behaviour of a INDIRECT formulae I created - a
rather simple one that that returns a listing of text from a sheet called
"customer list" (within the same workbook), depending on the result of a
Vlookup formula. The the VLOOKUP returns a range, say A50:A54, and
concatenating this with a sheet name 'customer list'! gives the range
reference INDIRECT needs.

My formulae as follows:

=INDIRECT(CONCATENATE("'customer list'!",VLOOKUP(Front!$C$12,'2006
MCs'!$B$2:$L$21,11,FALSE)))

I filled in this formula in cells A4 to A55 and was rather puzzled to see
that the cells A4 to A49 had #VALUE!, but Cells A50 to A54 had the desired
answers. Is it possible that the cells A4 always returns the first name in
the range, A5 the second name and so on.

Anything to clarify this welcome.
--
Andrew