Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

Enyaw wrote:

Is there any way to lookup values from another worksheet. The lookup array
is not sorted. I have tried offset and match but they did not work when the
other workbook is closed. Can anyone help?

--

Dave Peterson