Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would place the new column table in the same workbook (in a separate
sheet) as the original table, in case you haven't done that. Rather than a vlookup into a separate workbook (in case you are using separate workbooks). If you are already running from the same workbook, then are you using the false or true vlookup switch? In my experience if I use the false switch (=vlookup(somedata,mytable,3,false) to find an exact match, it runs faster with large tables. Maybe try sorting the original and vlookup tables first. Maybe that will help. You might also want to try the merge in Access, using SQL statements, if all else fails. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
Automatically update spreadsheet from another spreadsheet | Excel Worksheet Functions | |||
Can I 'auto update' my spreadsheet ? | Excel Worksheet Functions | |||
How do I add "headings" in spreadsheet to update in a TOC? | Setting up and Configuration of Excel | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) |