Biff,

It's going to be something like this

=OFFSET(PRODUCTS2!$B$1,0,(ROW()-3)*2)

but it is returning
0
in the cells
when i have text in

B1
D1
F1


It's an order form, going down first column is all the categories,
going down the first row is the categories, underneath is the
description, and in between each category is the sales price of
description....Example: (SP=sales price & C = Column ) I left out the
descriptions and the $ amount. See how I want the cat to follow going
down 1st column but not have the $SP going down the first column.

C-A1 C-B1 C-C1 C-D1 C-E1 C-F1
C-G1 C-H1
Cat ALBUSSON $SP ALBERTSON $SP ALEXANDRA $SP BLOCK
ALBUSSON
Albertson
Alexandra
Block

Hope that helps and doesn't confuse it more. Thanks!

KL




Max Wrote:
"Biff" wrote:
....
I don't know!
If that's what they want, then
why are they essentially transposing row 1 every othe cell?

I don't know why the OP wants it this way either <g,
but that's the way I interp'ed that part of the post/request literally
..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile: http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=376672