vlookup between a .xls and a .xlsx

[psrs0810]

Is there a way to do a vlookup between a .xls and a .xlsx? I keep getting an error because of the difference in the number of rows.

Thanks

 

[cjcobra]

are you going over the 65000 rows? I do vlookups between both all the time without any problems.

 

[psrs0810]

the error stats: Invalid reference. the file version cannot contain formulas that reference cells beyond a worksheet size of 256 columns or 65536 row.

My one file .xls has 2476 row of data, the other file has 435 rows, but does show the 1048576 total rows.

 

[november]

I have the same issue, this is a pain, **** MS! I should have kept 2003.

 

[psrs0810]

The way I got around this - instead of selecting columns for the Table_array, select an actual range - like A1:G435

HTH