Excel 2010 - Vlookup from .xlsx file to .xls

Dear Experts,

Can you please have a short look on the attached picture with the error message, I wanted just do a vlookup to D2 of Test1.xls from file Test1.xlsx.

Basically does it mean that not possible to do vlookup between older version of excel file and Excel 2010 file?

thanks,
Error-message.jpg
LVL 1
csehzIT consultantAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
MakriniConnect With a Mentor Commented:
Try
=vlookup(A2,[test1.xlsx]Sheet1$A$1:$L:$64000,0)

Entire columns in 2007 go up to a million rows whereas 2003 only goes to 64000.  Need to limit your lookup range
0
 
csehzIT consultantAuthor Commented:
Thanks I understand
0
All Courses

From novice to tech pro — start learning today.