[mso] Re: Outside data ?
- From: "Robert Carneal" <carnealre@xxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 1 Dec 2006 01:34:48 -0600
Responding to my own inquiry:
Should this formula work?
=VLOOKUP(B2,[C:\AllUSA5\Data\StateAbs.xls]Sheet1!,$StateAbbrevs,2)
I am using Excel 2000. Excel is complaining about the "C:" but I can't leave
it out; or can I? I two hard drives- C and D.
Sheet1 is where the data is located.
"StateAbbrevs" is the name of the range of data.
Thank you.
Robert
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of
Robert Carneal
Sent: 2006-11-30 23:47
To: mso@xxxxxxxxxxxxx
Subject: [mso] Outside data ?
Linda- do you have a resource I can read on for making a sheet containing
data (in this case, vintage abbreviations of states, not the current
abbreviations), so that I can use it for lookups?
Made-up (Not sure how referring to an outside workbook works):
Cell C2 contains "AZ"
In Cell D2, I would like to say:
=vlookup(C2, Bookname:Sheetname:Range,2) [Or whatever is correct in this
case]
And "Ariz." Gets entered into D2.
And in E2--
=vlookup(C2, Bookname:Sheetname:Range,3) [Or whatever is correct in this
case]
And "Arizona" gets entered into E2.
If not Linda, anyone else please? I had been copying this info on the sheet
itself to refer to it, but now that I am using it so much it would be nice
to be able to put it somewhere permanent I can refer to as needed.
Thanks.
Robert
*************************************************************
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:
