One try ..

Assume source data in Sheet1, cols A and B, from row1 down

In Sheet2,

you have this set-up:

Jan Feb Mar
AAA
BBB

where the AAA, BBB, etc are listed in A2 down

Put in B2:
=OFFSET(Sheet1!$A$1,MATCH($A2,Sheet1!$A:$A,0)+COLU MNS($A:A)-1,1)
Copy B2 across and fill down to populate
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ajnmx" wrote in message
...
Ok, this is driving me mad. I feel I should know the answer but I've
tried various combinations of lookups, indirects, offsets etc and I
just can't figure it out!

I have a list of data:


AAA
Jan 15
Feb 20
Mar 25

BBB
Jan 100
Feb 120
Mar 130

...and this goes on somewhat. I want to set up a new table like so:

Jan Feb Mar
AAA
BBB

...and populate it with the data from the first table. I can of course
do it with lookups but I have to change the range for each line. I
want to use one formula that I can just copy to all cells and it will
give the appropriate value. How???