Solved

Excel 2010 - Vlookup from .xlsx file to .xls

Posted on 2011-09-12
2
969 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
Comment Utility
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
Comment Utility
Thanks I understand
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now