Help with database formula.

B

Bazza

I will reword my previous question because after looking at it I think I
worded it incorrectly.
I have a database that collects customers surnames, middle names,
address, towns, etc. So if we take the first entry under surnames I
have the T formula which refers to the cell and column where the info
is, eg: =T('Shop Invoice'!D29) the next cell down, again under surname
has =T('Shop Invoice'!D87).
What I need to know is what do I have to add to the second formula so
that I can autofill each successive cell to look at the next cell of
information 58 cells down from the previous one.
Any help would be greatly appreciated, Thanks

Bazza
 
B

Bob Phillips

=T(INDIRECT("'Shop Invoice'!D"&29+(ROW(A1)-1)*58))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top