formula to copy data from left to right

[howard]

I have the following data in b2:B6. I have the on several sheet and want to

Book1
	A	B
1	Ageing
2	0-30	6515
3	30-60	9025
4	60-90	825
5	90-120	1005
6	>120	927
Sheet1

I have summary sheet and have tried to use an Index formula to extra the data going across from Left to Right, but only get the correct value for 0-30



It would be appreciated if someone could kindly assist me

Book1
	B	C	D	E	F
1	0-30	30-60	60-90	90-120	>120
2	6515	6515	6515	6515	6515
3
Summary

Cell Formulas
Range	Formula
B2	=INDEX(Sheet1!$B3:$B3,ROWS(Sheet1!3:3)-ROWS(Sheet1!3:3)+1)
C2	=INDEX(Sheet1!$B3:$B3,ROWS(Sheet1!3:3)-ROWS(Sheet1!3:3)+1)
D2	=INDEX(Sheet1!$B3:$B3,ROWS(Sheet1!3:3)-ROWS(Sheet1!3:3)+1)
E2	=INDEX(Sheet1!$B3:$B3,ROWS(Sheet1!3:3)-ROWS(Sheet1!3:3)+1)
F2	=INDEX(Sheet1!$B3:$B3,ROWS(Sheet1!3:3)-ROWS(Sheet1!3:3)+1)

 

[jmacleary]

Try '=vlookup(B$1,Sheet1!$a$1:$b$6,2,false)' in your cell B2. Drag across to f2. You would then copy it down, changing Sheet1 to the right name on each row.

 

[howard]

Thanks for your help