Solved: Using VLOOKUP command

[Tenspeed39355]

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

[austenr]

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]

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]

What is wrong with this?
=VLOOKUP(A2,C:\Desktop\[Test.xls]Sheet1!A2:$b$50,2,0)
What am I leaving out
Max

[malik641]

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]

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