Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JodyGlenn
 
Posts: n/a
Default Vlookup between two workbooks

I have two workbooks linked across a network with a Vlookup function for
information that is time sensitive and needs to be updated quickly. When I
enter a value in Workbook A which requires info that is recently entered at
the end of the list of the Workbook B, it doesn't return the correct info.
It returns a value several lines above almost as if there hasn't been a
recent update and what it is returning is the last thing it remembers . The
F9 manual function works but an extra keystroke is cumbersome with this
application, and the majority of the time the automatic update works. Is
there an update timer and a way to set it to very short intervals?
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
vlookup not working (active) - 2 workbooks goofy11 Excel Discussion (Misc queries) 2 January 16th 11 08:12 AM
VLookup across Workbooks? PH NEWS Excel Worksheet Functions 0 April 24th 06 03:43 PM
How do I use VLOOKUP to ref multiple workbooks with multiple tabs? JackieW Excel Discussion (Misc queries) 2 April 11th 06 05:32 PM
Vlookup in Multiple Workbooks Excelcrazy Excel Discussion (Misc queries) 3 December 20th 05 02:56 PM
Vlookup between two workbooks kalz Excel Worksheet Functions 1 December 7th 04 11:35 AM


All times are GMT +1. The time now is 09:15 PM.

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

About Us

"It's about Microsoft Excel"