Seems we both caught it (B8 - B1) at about the same time.

And, to prove our great minds work in unison, we both went with the "+1",
didn't we?<g

I'm confused with your INT though?!?!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Max" wrote in message
...
Believe the OP's latest post did say:
.. the value from 'ED Numbers'!B1,
and the value from 'ED Numbers'!C1

(I fell for the line "8" which s/he posted yesterday)

in which case, perhaps a slight tweak to your formula in B1

Try this in B1:
="HD_SN "&'ED Numbers'!$A$23&INDEX('ED Numbers'!$B:$B,
(ROW(1:1)-1)/3+1)&INDEX('ED Numbers'!$C:$C,(ROW(1:1)-1)/3+1)&"T"
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--