[mso] Re: Excel Cross-reference
- From: "IBS4U" <IBS4U@xxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 25 May 2004 19:48:05 -0700
Thanks, Ray. VLOOKUP seems to be what I need. However, I'm not concerned
about the names in Col. A because in some cases it's the wife's name,
sometimes it might be the husband's name or both names. The address would
be the cross-reference I'm looking for.
Would I still use the first example you referenced?
I have never used VLOOKUP before. Therefore, I'm not sure how to change it
if I need to.
I appreciate your comment regarding Excel and Access. I prefer to use Excel
whenever I can even if it's only for addresses.
Carol R.
Innovative Business Solutions
----- Original Message -----
From: "Ray Blake" <ray@xxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Tuesday, May 25, 2004 9:37 AM
Subject: [mso] Re: Excel Cross-reference
> Yes, sort of. First of all, never apologise for using Excel when you
> could have used Access. In my experience, much grief is derived from
> using Access when Excel would have sufficed.
>
> Anyway, what you need to do is use a VLOOKUP in the address column on
> your second worksheet which seeks to match the name entered in the first
> column with a corresponding entry on the other sheet. Assuming the
> sheets are 'Sheet1' and 'Sheet2' and that neames appear in column A and
> addresses in B, the formula in B1 on Sheet2 is like this:
>
> =VLOOKUP(A1,Sheet1!A:B,2,FALSE)
>
> Drag it down the length of column B. If you enter a name and there's no
> match, the cell will show an NA error, and you can simply overtype the
> new address. If you'd rather the cell looked empty than display an
> error, then change the formula to this:
>
>
> =IF(ISNA(VLOOKUP(A1,Sheet1!A:B,2,FALSE)),"",VLOOKUP(A1,Sheet1!A:B,2,FALS
> E))
>
> Ray Blake
>
> ------------------------------------
> GR Business Process Solutions
> Ray Blake
> Head of Software Design
> ray@xxxxxxxxx
> Braedon
> Newell Road
> Hemel Hempstead
> Herts HP3 9PD
> tel: 01442 396518
> fax: 01442 389353
> www.grbps.com
> ------------------------------------
>
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf Of IBS4U
> Sent: 25 May 2004 16:21
> To: mso
> Subject: [mso] Excel Cross-reference
>
>
> Hi, all. Is there a way to cross-reference worksheets?
> I have a database of names, addresses & info in 2 large workbooks. If I
> start to type in duplicate info (i.e., address) for this person, is
> there a way the info will view as an "auto type" so that I know it's in
> the other worksheet?
>
> You may wonder why I've done this in Excel -- it's because we also have
> calculations. Management wants the spreadsheets to be done quarterly,
> i.e., Jan - Mar., Apr. - June.
>
> Thanks so much for your help.
>
> Carol R.
> Innovative Business Solutions
>
> *************************************************************
> 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, send an email to
> mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line.
>
> Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> To be able to use the files section for sharing files with the group, send
a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
> http://www.smartgroups.com/vault/msofiles
> *************************************************************
>
*************************************************************
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, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
