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