Solved

Excel 2010 - Vlookup from .xlsx file to .xls

Posted on 2011-09-12
2
979 Views
Last Modified: 2012-05-12
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
Comment
Question by:csehz
2 Comments
 
LVL 10

Accepted Solution

by:
Makrini earned 500 total points
ID: 36521616
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
 
LVL 1

Author Closing Comment

by:csehz
ID: 36521631
Thanks I understand
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question