Posted to microsoft.public.excel.programming

external usenet poster

Posts: 58

match/Offset help

I am having issues with a formula that uses match and offset. The formula
links to a closed workbook and if this workbook is closed when the file
opens, the formula #VALUES and will not update until I open the source. Any
help on this?

I am using offset and match to make a complex lookup.

I thought I read somewhere that certain formulas will not update unless the
source file is open, but can't find anything in my search today.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
offset match	Enyaw	Excel Discussion (Misc queries)	1	February 17th 10 12:54 PM
OFFSET & MATCH	Warren Easton	Excel Discussion (Misc queries)	2	July 21st 08 03:22 PM
match and offset	Jaybird[_3_]	Excel Programming	8	May 7th 08 04:50 PM
If And Match With a MAX and Offset	[email protected]	Excel Discussion (Misc queries)	7	October 23rd 06 12:57 PM
Using MAX with OFFSET and MATCH	Joe Gieder	Excel Worksheet Functions	3	October 12th 05 10:34 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us