[mso] Re: Outside data ?
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 1 Dec 2006 16:13:15 -0500
Sorry .. I see I used a French bracket instead of a flat bracket (working
from memory and in a hurry here).... Here it is again:
=VLOOKUP(B2,'C:\AllUSA5\Data\[StateAbs.xls]Sheet1'!,StateAbbrevs,2,FALSE)
If I still got it wrong, just follow my directions below to let Excel enter
the path for you ... Then you'll be sure it's correct
Linda F. Johnson
Linda's Computer Stop
Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
http://personal-computer-tutor.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Linda F. Johnson
Sent: Friday, December 01, 2006 10:13 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Outside data ?
Robert ... The easiest way to do this is to just open the second workbook
along with the workbook where you are entering the VLOOKUP formula ....
Then, start typing the formula and when you get to the part of the formula
where you need to enter the reference to the other workbook, just move to
that workbook and select the range (in your case I see it's a named range,
so just use the Name box dropdown to select that name) .... Excel will enter
it correctly for you. Once you save the workbook with the formula in it,
Excel will add the path to the other workbook so you can see it in the
formula bar
But, to answer your question, here's how the formula should look:
=VLOOKUP(B2,'C:\AllUSA5\Data\{StateAbs.xls]Sheet1'!,StateAbbrevs,2,FALSE)
I've included FALSE to get an exact match ... If you truly only want an
approximate match, then leave FALSE out.
Linda F. Johnson
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
