View Full Version : Solved: Using VLOOKUP command
Tenspeed39355
11-16-2005, 06:36 PM
Hi guys. I have looked in my Excel book for this answer, no luck.
What is the VLOOKUP command to look in another workbook for information.
This is as far as I have gotten.
=VLOOKUP(A2,TEST!,Sheet1!A2:B50,2,0) Where am I wrong?
Thanks
Max:hi:
austenr
11-16-2005, 06:52 PM
Hi Ten,
Looks like you have two sheets defined there. Try removing either TEST! or Sheet1!. The ! is what tells excel to look in a sheet other than the one you are in. HTH
Shazam
11-16-2005, 07:06 PM
You'll need to put a path in your formula.
Example:
=VLOOKUP(A19,'C:\Documents and Settings\My Documents\[Book555555.xls]Sheet1'!$A$1:$B$50,1,0)
Tenspeed39355
11-16-2005, 07:29 PM
What is wrong with this?
=VLOOKUP(A2,C:\Desktop\[Test.xls]Sheet1!A2:$b$50,2,0)
What am I leaving out
Max
malik641
11-16-2005, 09:05 PM
Hey Max
Shazam's steering you in the right direction and I don't think anything's wrong with your formula...but if you're getting an error the only thing I could suggest is adding the single quotation marks as such:
=VLOOKUP(A2,'C:\Desktop\[Test.xls]Sheet1'!A2:$b$50,2,0)
If this is invalid then make sure you are referencing the correct path, workbook, and sheet name.
Tenspeed39355
11-17-2005, 06:54 AM
Hi guys I found the path that works for me.
Thanks for all the help.
I have one question. What does the single quote ' have to do with the formula. I have tried running the formula without the single quote but it will not work without it.
I am trying to learn as much as I can from you guys. The quick response and the answers
to all the problems I have presented have been solved in super quick time. It is like having a teacher on hand all the time.
Keep up the great work.
I will close this thread and give it a rating
Max
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.