I have a spreadsheet with over 60K rows that I need to update with an
additional column of data. Unfortunately it would be too much work to repull
the data and get it formatted appropriately. I was planning to use vlookup
to complete the update but so far has been very time consuming. Does anyone
have a better option not requiring VBA?

Assuming the table with the new column has a matching (key) field in
the original table, why would vlookup take too long? You can create
the vlookup formula in the first row, then double click the lower
right corner of that cell to copy straight down through the entire
table?

It keeps timing out so I've been forced to go approx 3000 rows at a time. Is
there another way to do it?

"HKaplan" wrote:

Assuming the table with the new column has a matching (key) field in
the original table, why would vlookup take too long? You can create
the vlookup formula in the first row, then double click the lower
right corner of that cell to copy straight down through the entire
table?

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.