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?