[mso] Re: VLookUp
- From: Viola R Robinson <pavrr@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Fri, 12 Nov 2004 07:21:47 -0800 (PST)
Linda:
Thank you for your help and the excellent tutorial. I apologize that I am
unable to express in words the confusion I feel when trying to work with Excel
and Access. Yet, trying to put the explanation in writing when something goes
wrong is worse.
*****************************************************************
Christine:
You read my mind. You were absolutely right in changing the format of the
column to general.
Viola
"Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I'm not sure what "message" you are referring to? And what's the "Revenue
File"?
Maybe my tutorial on VLOOKUP formulas will help you, since you didn't supply
enuf info here to help....read this and follow the instructions and then let
us know if you still get some message, but tell us what the message is:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=446
If that link wraps, use this one:
http://snipurl.com/akup
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine ~ Free Ebooks and Tutorials
*all outgoing mail scanned by Norton AV. If you got a bug that looks like
it came from me, it did NOT!
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Viola R Robinson
Sent: Thursday, November 11, 2004 3:05 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] VLookUp
Could someone help me please? I am trying to do a VLookup. Why does this
message keep apperaing instead of the expected result?
=VLOOKUP(B2,'Census 0904'!A:B,2,false)
I am trying to link the index number from the census file to the index
column (blank) on the revenue file.
Position of columns on the Revenue File:
1. Index (Blank Column)
2. Patient Account
Position of columns on the Census File:
Position of columns on the Revenue File:
1. Index (Populated w/index number)
2. Patient Account
Thank you in advance. You kindness is greatly appreciated.
Viola R. Robinson
*************************************************************
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
*************************************************************
Viola R. Robinson
Total Outsourcing Network
Coalition of Healthcare Administrative Management Professionals
Phone: (215) 549-4015
Fax: (215) 924-8777
consumer@xxxxxxxxxxxxxxxxxxxxxx
http://www.heavyweightpartner.com
---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com
*************************************************************
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:
