[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1095
  • Last Modified:

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
0
csehz
Asked:
csehz
1 Solution
 
MakriniCommented:
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
 
csehzAuthor Commented:
Thanks I understand
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now