Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 21st 06, 10:00 PM posted to microsoft.public.excel.worksheet.functions
MKunert
 
Posts: n/a
Default Offset function with nested match function not finding host ss.

I have an offset function with a nested match function that looks to a
separate spreadsheet. If I have both spreadsheets open, it works fine. If
the host ss is not open, I get a #VALUE! error. The vlookups on the sheet
look to the same host spreadsheet, and they are not affected. Any ideas?

  #2   Report Post  
Old March 21st 06, 10:46 PM posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Offset function with nested match function not finding host ss.

That's the way it is, OFFSET does not work with closed workbooks, if you can
replace with index and match it will work


Regards,

Peo Sjoblom


"MKunert" wrote in message
...
I have an offset function with a nested match function that looks to a
separate spreadsheet. If I have both spreadsheets open, it works fine.
If
the host ss is not open, I get a #VALUE! error. The vlookups on the sheet
look to the same host spreadsheet, and they are not affected. Any ideas?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF function with 14 nested levels Dan Fingerman Excel Worksheet Functions 3 September 5th 05 05:57 PM
Complicated Index Match Offset function Bob Excel Worksheet Functions 6 September 5th 05 03:01 PM
Links to 2nd closed worksheet fail when using offset function ?? Jordan795 Excel Worksheet Functions 1 June 21st 05 01:43 AM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Offset, indirect, match function limitation on linked worksheets. NewAlgier Excel Worksheet Functions 1 December 6th 04 11:55 PM


All times are GMT +1. The time now is 01:58 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017