Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup not working (active) - 2 workbooks | Excel Discussion (Misc queries) | |||
VLookup across Workbooks? | Excel Worksheet Functions | |||
How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) | |||
Vlookup in Multiple Workbooks | Excel Discussion (Misc queries) | |||
Vlookup between two workbooks | Excel Worksheet Functions |