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
--
Tiesthatbind
------------------------------------------------------------------------
Tiesthatbind's Profile:
http://www.excelforum.com/member.php...o&userid=32360
View this thread:
http://www.excelforum.com/showthread...hreadid=560397