Just slightly more concise, with no restraints on the range to be copied:

=INDEX(Itemval!$B:$B,COLUMNS($A:E))

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Domenic" wrote in message
...
Try...

=INDEX('Itemval'!$B$5:$B$149,COLUMNS('Sheet1'!$G2: G2))

Hope this helps!

In article ,
Tiesthatbind
wrote:

Hi all, I guess I need further help to reverse the formula. I now need
to take column B5 on tab 'Itemval' and have it read on to tab 'Sheet1'
. Thought to take the Domenic contributed formula and do this:
=INDEX('Itemval'!$B5:$B$149,COLUMNS('SHEET1'!G$2:G 2)). but when i drag
this formula across Sheet1 row 2, only the contents of Itemval B5 read
though. Where did I go wrong? Thank you. J