ExcelBanter - offset match

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - offset match (https://www.excelbanter.com/excel-discussion-misc-queries/256498-offset-match.html)

enyaw

offset match

How do i use this formula to return values from another workbook without
having to open the source data. It tells me the formula is volatile. I
cannot use a lookup as i cant sort the data. Can anyone help?

Jacob Skaria

offset match

Enya, please refer your previous post
--
Jacob

"Enyaw" wrote:

How do i use this formula to return values from another workbook without
having to open the source data. It tells me the formula is volatile. I
cannot use a lookup as i cant sort the data. Can anyone help?

All times are GMT +1. The time now is 05:01 PM.