I currently have an offset match formula that returns values from another
workbook. The problem is the other workbook must be open or else the formula
becomes volatile. I cannot use a lookup because i cannot sort the data. Is
there any way of retrieving the information witout opening the source
workbook?