=index('week 1'!g:g,match("somevalue",'week 1'!z:z,0))
Debra Dalgleish has some nice instructions:
http://contextures.com/xlFunctions03.html
Gef wrote:
In Office 2000, I have 4 sheets - week 1 to 4. I want to search a particular
column for specific text and return a value from the column to the left of
the text.
Any ideas?
Thanks in advance.
--
Dave Peterson