[mso] Re: Outside data ?
- From: Wilson Baptista Junior <wilsonbaptista@xxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sat, 02 Dec 2006 19:57:38 -0200
Hi Robert,
you'll need to have the two workbooks open for your lookup to work, so you=
don't need the workbook path. Open the two workbooks, then use the formula=
wizard in Excel to set up the formula. Assuming your abbreviation table is=
on Sheet1 of workbook StateAbs, and you're using the formula in another=
workbook, you'll get something like this:
=3DVLOOKUP(C2,[StateAbs.xls]Sheet1!Stateabbrevs,2;FALSE)
As long as the two workbooks are open you don't need to know their paths.
Wilson
At 05:34 1/12/2006,Robert Carneal wrote:
>Responding to my own inquiry:
>
>Should this formula work?
>
>=3DVLOOKUP(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:
>
>=3Dvlookup(C2, Bookname:Sheetname:Range,2) [Or whatever is correct in this
>case]
>And "Ariz." Gets entered into D2.
>
>And in E2--
>=3Dvlookup(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
>*************************************************************
>
>Esta mensagem foi verificada pelo E-mail Protegido Terra.
>Scan engine: McAfee VirusScan / Atualizado em 30/11/2006 / Vers=E3o:=
4.4.00/4908
>Proteja o seu e-mail Terra: http://mail.terra.com.br/
*************************************************************
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:
